title: Square bracket us in SQL statements for wildcards
body: <p>When I use square brackets with a <code>%</code> wildcard as below MySQL does not select any records starting with a number. Many examples across the internet state this as the correct use. Any suggestions? It doesn't work for a letter (<code>a-d</code>) range either. I'm running MySQL 3.2</p>
  
  <pre><code>SELECT * FROM customers WHERE lname LIKE '[0-9]%' ORDER BY lname ASC
  </code></pre>
  
  <p>or</p>
  
  <pre><code>SELECT * FROM customers WHERE lname LIKE '[a-d]%' ORDER BY lname ASC
  </code></pre>