|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
Check out the DISTINCT keyword
select distinct(username) as username from table |
![]() |
| Viewing: Dev Shed Forums > Databases > MySQL Help > selecting unique value from a column |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|