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