Query for counting unique values

[TheDust]

I'm trying to find out if I can construct a query to MySQL that will return the number of unique values in a given column. The reason is because I have a column that just contains just the YEAR of a given report. I want to see how many different values populate the YEAR column through the entire query result so I know how many tables to render on screen (one table for each year).

Any help would be very much appreciated.... thanks!!

 

[ericbrunson]

Did you try:
select count( distinct( mycolumn ) ) from mytable;
or
select count( mycolumn ) from mytable group by mycolumn;