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