SELECT msg, COUNT(*) AS total
FROM <table_name>
WHERE LOWER(msg) LIKE 'vote %' COLLATE _your_collation_name_goes_here
GROUP BY msg ORDER BY total DESC;
SELECT DISTINCT(REPLACE(message,'Vote ', '')) AS message, COUNT(*) AS votes
FROM _messages
GROUP BY message ORDER BY votes DESC