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