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