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