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