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