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