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