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