General Community > Scripting Help

MySQL Question

(1/1)

Minion:
Ok.  i have a table with a row that was, lets say, various entries of years.

(2003, 2003, 2002, 2002, 2003, 2003, 2001, 2001, 2001, 2000, 2000,)

Is there a function (or way) that will allow me to select dates from this column where my result would be:

(2003, 2002, 2001, 2000)

I need it for dropdowns.

Thanks.

Jeff Lewis:
Don't have the exact code but look up UNIQUE in the mySQL docs (or someone here will post it)

Parham:
i thought it had to do with DISTINCT...?

Minion:
*checking

Jeff Lewis:
My bad, wrong keyword :)

Navigation

[0] Message Index