select majority?

[Anon]

Is there something like this in mysql? I searched the mysql docs, but I really didn't know what to call what I am looking for.

In my table I have a column that has one of two possible values. They are stored as text rather than a number, to make it easier on me. What I want is to find out the most common value of that column.

Example:
column name is "favorite_fruits"
apple
orange
pear
apple
orange
orange

My goal is to return "orange" in this case.

[Anon]

select favourite_fruits,count(*) as most_common
from f
group by favourite_fruits
order by most_common desc
limit 1

[Anon]

Thanks a bunch!!