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