MySQL - How to get DISTINCT or UNIQUE ?

How to get the 4th field to be DISTINCT among 4 fields?

[bgb76]

Hi Masters,

I'm facing this delima that among 4 fields, I want the 4th field to be DISTINCT. How?

cno
cfname
cphone
cemailid -- DISTINCT

select DISTINCT cemailid, cno,cfname,cphone from rform (not working)

Kindly help me, Please...

Thanks in Advance.
Bharadwaj

[brotherhood of LAN]

This should work,

SELECT select cemailid, cno,cfname,cphone
FROM rform
GROUP BY cphone

See [dev.mysql.com...]

[bgb76]

Thank You Bro,

No avail. I tried. 544 records on distinct on "cemailid" after adding another field, the record shoot upto 612.

Still trying.

Thanks for help.

[brotherhood of LAN]

GROUP BY field will most definitely give you distinct values. Maybe you should check for trailing newlines & spaces in those fields.

[staceybrown281]

Better use Group by Syntax that using the keyword DISTINCT.

[Dijkgraaf]

bortherhood of LAN is right in principle, but wrong in detail ;-), if you want to be distinct on cemailid you need to group on cemailid

SELECT select cemailid, cno,cfname,cphone
FROM rform
GROUP BY cemailid