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