SELECT id FROM users WHERE active=1 AND about_me LIKE "%rap hip-hop specter SpecterMusic%" ORDER BY username ASC, num_followers DESC
0.03725
SELECT id FROM users WHERE tags REGEXP "(^|\,| )rap hip\\-hop specter SpecterMusic($|\,)" ORDER BY username ASC
0.01366
SELECT id FROM users WHERE active=1 AND (username LIKE "%rap hip-hop specter SpecterMusic%" OR fullname LIKE "%rap hip-hop specter SpecterMusic%" OR position LIKE "%rap hip-hop specter SpecterMusic%") ORDER BY username ASC
0.01106
SELECT id FROM users WHERE active=1 AND (username="rap hip-hop specter SpecterMusic" OR fullname="rap hip-hop specter SpecterMusic" OR position="rap hip-hop specter SpecterMusic") ORDER BY username ASC
