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