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