#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Posts
    31
    Rep Power
    15
    how do i do a select to show my all the unique values in a column?

    example:
    i have a table the stores username, date, data, otherstuff everytime an user submits a web form. i want to build a list of all the unique users in the table.

    thanks,
    deno
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    Check out the DISTINCT keyword

    select distinct(username) as username from table

Similar Threads

  1. Replies: 2
    Last Post: October 11th, 2003, 08:52 PM
  2. not possible to SELECT-WHERE primary key fields?
    By mithril in forum MySQL Help
    Replies: 2
    Last Post: July 18th, 2003, 02:16 PM
  3. Replies: 6
    Last Post: October 28th, 2002, 01:27 PM
  4. selecting unique values
    By madhats in forum MySQL Help
    Replies: 1
    Last Post: August 10th, 2002, 04:52 AM
  5. Replies: 3
    Last Post: August 9th, 2002, 01:05 PM

IMN logo majestic logo threadwatch logo seochat tools logo