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