Select all unique collumn entries in mysql

[monomaniac21]

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

[Erwin Moller]

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