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