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