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