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