You need to group by the interesting column and for each value, select the value itself and the number of rows in which it appears.
Then it’s a matter of sorting (to put the most common value first) and limiting the results to only one row.
In query form:
SELECT column, COUNT(*) AS magnitude
GROUP BY column
ORDER BY magnitude DESC