title: Selecting rows where first n-chars are equal (MySQL)
body: <p>I have a table with playerhandles, like this:</p>
  
  <pre><code>1 - [N] Laka
  2 - [N] James
  3 - nor | Brian
  4 - nor | John
  5 - Player 2
  6 - Spectator
  7 - [N] Joe 
  </code></pre>
  
  <p>From there I wanna select all players where the first n-chars match, but I don't know the pattern, only that it's the first n-chars. In the above example I wan't it to return rows 1,2,3,4 and 7.</p>
  
  <p>Is this possible and not too expensive to do in MySQL?  </p>