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