SELECT id FROM users WHERE active=1 AND about_me LIKE "%#euro2012%" ORDER BY username ASC, num_followers DESC
0.01243
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#euro2012($|\,)" ORDER BY username ASC
0.02339
SELECT id FROM users WHERE active=1 AND (username LIKE "%#euro2012%" OR fullname LIKE "%#euro2012%" OR position LIKE "%#euro2012%") ORDER BY username ASC
0.02047
SELECT id FROM users WHERE active=1 AND (username="#euro2012" OR fullname="#euro2012" OR position="#euro2012") ORDER BY username ASC