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