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