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]

Re: Select all unique collumn entries in mysql

monomaniac21 wrote:
[color=blue]
> 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[/color]

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