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