Most Common Column Data

[mrknowledge]

Is there a way to search for the most common value in a column?  Like if i have 5 rows, and 3 have the value='foo' in the third column, can i have it return that value without having to create a function?

thanks

[shoz]

[code]
SELECT
column, COUNT(*) AS n
FROM
tablename
GROUP BY
column
ORDER BY
n DESC
LIMIT 1
[/code]

Note that if multiple values are repeated just as frequently the one selected will be somewhat random.

[mrknowledge]

Thanks, that did the trick.