homepage Welcome to WebmasterWorld Guest from 54.225.1.70
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
MySQL - How to get DISTINCT or UNIQUE ?
How to get the 4th field to be DISTINCT among 4 fields?
bgb76




msg:4488533
 1:35 am on Aug 27, 2012 (gmt 0)

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




msg:4488538
 2:05 am on Aug 27, 2012 (gmt 0)

This should work,

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

See [dev.mysql.com...]

bgb76




msg:4488542
 2:16 am on Aug 27, 2012 (gmt 0)

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




msg:4488543
 2:31 am on Aug 27, 2012 (gmt 0)

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

staceybrown281




msg:4495742
 12:56 pm on Sep 16, 2012 (gmt 0)

Better use Group by Syntax that using the keyword DISTINCT.

Dijkgraaf




msg:4500008
 4:17 am on Sep 26, 2012 (gmt 0)

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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved