Hi
Thanx for both your replies, until recently I was doing the intelligent stuff outside
MySql ie in the Perl/PHP.
I'm learning to think database!!
Best Regards
David Rayner MSc CEng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi Y'All
I need to test if any values in a column are the same (or are unique)
eg (my made up syntax Unique)
SELECT * from tbl_addresses WHERE txtName is UNIQUE;
How should this be done???
zzapper
--
vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?
On Monday 24 November 2003 03:25 pm, zzapper wrote:
Hi Y'All
I need to test if any values in a column are the same (or are unique)
eg (my made up syntax Unique)
SELECT * from tbl_addresses WHERE txtName is UNIQUE;
SELECT DISTINCT txtName from tbl_addresses;
--
MySQL General Mailing List
On Nov 24, 2003, at 6:25 PM, zzapper wrote:
I need to test if any values in a column are the same (or are unique)
eg (my made up syntax Unique)
SELECT * from tbl_addresses WHERE txtName is UNIQUE;
How should this be done???
To get a list of all 'txtName' values that appear only once in the