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