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