Selecting rows where first n-chars are equal (MySQL)

1 - [N] Laka
2 - [N] James
3 - nor | Brian
4 - nor | John
5 - Player 2
6 - Spectator
7 - [N] Joe

select name from players p1 where exists (
  select 1 from players p2 where
    p2.name like CONCAT( SUBSTRING(p1.name, 1, 3), '%')
    and p1.name <> p2.name )

Select *
FROM players
WHERE Left(name, 3) in (
   SELECT Left(name, 3)
   FROM players
   GROUP BY Left(name, 3)
   HAVING (Count(*) > 1)
);