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