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