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