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