Select * Where sortoflikeDistinct(`column`);
Posted: Wed Mar 21, 2007 9:07 pm
Er.. I have rows something like:
Now, I need a query to give me all the different tags (the last row (park, green, etc)).
From the above rows, I would expect back: park, green, ugly, ocean.
Basically, I need a DISTINCT that works on a single column. Is there some way I can do that in the query?
Code: Select all
324, file1.jpg, park
325, file1.jpg, green
326, file1.jpg, ugly
682, file5.jpg, ocean
683, file5.jpg, green
938, file8.jpg, oceanFrom the above rows, I would expect back: park, green, ugly, ocean.
Basically, I need a DISTINCT that works on a single column. Is there some way I can do that in the query?