select same field as two names

Forum Moderators: open

Message Too Old, No Replies

10:19 am on Apr 11, 2008 (gmt 0)

Hi guys, I want to select the distinct value of a field (category) as two names -> value and label

How do I do It?

SELECT distinct(category) as label, distince(category) as value from mldc_stocks;

This one doesn't work.
Please help!

4:10 pm on Apr 11, 2008 (gmt 0)

you only need the distinct once.

SELECT distinct(category) as label, (category) as value from mldc_stocks;

5:00 pm on Apr 11, 2008 (gmt 0)

thanks