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