468,247 Members | 1,293 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,247 developers. It's quick & easy.

Select all unique collumn entries in mysql

Hi all

Can anyone tell me how you can query mysql for all unique entries into
a particular table collumn. Ive checked the manual but had no luck!

Kind regards

marc

May 30 '06 #1
1 2021
monomaniac21 wrote:
Hi all

Can anyone tell me how you can query mysql for all unique entries into
a particular table collumn. Ive checked the manual but had no luck!

Kind regards

marc


Hi,

I don't know mySQL too well, but every DB that understands SQL should have a
modifier named DISTINCT.
SELECT DISTINCT firstname FROM tblpeople;

Regards,
Erwin Moller
May 30 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Benjamin Dickgießer | last post: by
3 posts views Thread by Sven Reifegerste | last post: by
1 post views Thread by windandwaves | last post: by
3 posts views Thread by Kall, Bruce A. | last post: by
4 posts views Thread by monomaniac21 | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.