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