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