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