MySQL Query help, Please... 1

[admoore]

Lets say I have a field in a table with records like this:

shirt XL blue
shirt M blue
shirt S red
pants 32L denim
socks S white

And I want a query to list all of the UNIQUE contents of the item field; i.e. the results would be:

shirt
pants
socks

This should not be too difficult; but I can't seem to get it...

Many TIA,

-Allen

 

[ingernet]

the keyword you're looking for in your SQL statement is "distinct." here's an example of how to use it:

let's say your table is named CLOTHES, and the column that has "shirt, pants, socks" in it is called clothing_item.

$myquery = "select DISTINCT clothing_item from CLOTHES";

this will pull only one instance of each different kind of item in the clothing_item column.

hope this helps!
inger