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