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