title: Select all where [first letter starts with B]
body: <p>This is a follow up question to my previous one. I want to write a MYSQL statement that echoes every entry that starts with letter B. </p>
  
  <p>Function.php</p>
  
  <pre><code>function getCategory() {
  $query = mysql_query("SELECT author FROM lyrics WHERE author [starts with letter B]") or die(mysql_error());
  while ($row = mysql_fetch_assoc($query)) { ?&gt;
      &lt;p&gt;&lt;a href="##"&gt;&lt;?= $row['author']; ?&gt;&lt;/a&gt;&lt;/p&gt;
      &lt;?php }
  </code></pre>
  
  <p>Category.php?category=b</p>
  
  <pre><code>&lt;?php include 'includes/header.php' ?&gt;
  &lt;?php getCategory(); ?&gt;
  &lt;?php include 'includes/footer.php' ?&gt;
  </code></pre>
  
  <p>Like that I guess. And then one for every letter of the alphabet, and one with misc (numbers etc)</p>