title: Using Substring in MySQL criteria
body: <p>I'm trying to fetch all instances where the 1st letter of a person's first name is equal to <em>P</em>.</p>
  
  <p>This is what I came up with, which doesn't return anything:</p>
  
  <pre><code>$sql="SELECT * FROM people WHERE SUBSTRING(FirstName,0,1) = 'P'";
  </code></pre>
  
  <p>Suggestions?</p>