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