title: Select Query | Select Entires That Don't Start With A Number - MySQL
body: <p>I need to select all entries that do not start with a number between 1-9.  </p>
  
  <p><strong>Example Entries</strong>:</p>
  
  <ul>
  <li>6300 Dog Lane </li>
  <li>Kitty Drive</li>
  <li>500 Bird Chrest</li>
  <li>800 Tire Road</li>
  <li>Johnson Ave</li>
  <li>Park Ave</li>
  </ul>
  
  <p><strong>So if I ran a query on the above I would expect</strong>:</p>
  
  <ul>
  <li>Kitty Drive</li>
  <li>Johnson Ave</li>
  <li>Park Ave</li>
  </ul>
  
  <p>Table is called <code>objects</code> and the column is called <code>location</code>.</p>
  
  <p><strong>Something I tried</strong>:</p>
  
  <pre><code>SELECT DISTINCT name, location FROM object WHERE location NOT LIKE '1%' OR '2%' OR '3%' OR '4%' OR '5%' OR '6%' OR '7%' OR '8%' OR '9%';
  </code></pre>
  
  <p>Unfortunately, that is unsuccessful.  If this is not possible please let me know and I will resort to modifying the data with Perl.</p>
  
  <p>Thank You</p>