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