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