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