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