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