Select all unique collumn entries in mysql

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • monomaniac21

    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

  • Erwin Moller

    #2
    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

    Comment

    Working...