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