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