SELECT id FROM users WHERE active=1 AND about_me LIKE "%#American-football%" ORDER BY username ASC, num_followers DESC
0.00821
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#American\\-football($|\,)" ORDER BY username ASC
0.01272
SELECT id FROM users WHERE active=1 AND (username LIKE "%#American-football%" OR fullname LIKE "%#American-football%" OR position LIKE "%#American-football%") ORDER BY username ASC
0.01343
SELECT id FROM users WHERE active=1 AND (username="#American-football" OR fullname="#American-football" OR position="#American-football") ORDER BY username ASC