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