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