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