selecting the single most common value from a certain column?

Hi is there a way of selecting the single most common value from a
certain column in a mysql table?

Thanks a lot,
Ciarán

Ciaran wrote:
> Hi is there a way of selecting the single most common value from a
> certain column in a mysql table?
>
> Thanks a lot,
> Ciarán

SELECT column_name, count(*) as quantity
FROM table_name
GROUP BY column_name
ORDER BY quantity DESC
LIMIT 1

Wow! I'm not sure what it means but it works great! Thanks a lot!