Posted by Erwin Moller on 05/30/06 09:32

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

[Back to original message]