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