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