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