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