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