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