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