title: MySQL query select where columns contains numbers and letters
body: <p>I need to filter a column to get only rows which contain letters and numbers. 
  Its because I need to get all real license plates.
  License plates are like: AB12CD or AB123C, So they always contain numbers and letters. I don't know how to do this.</p>
  
  <p>First I tried to look if the licenseplate was a number with IsNumeric(licenseplate) = 1 to filter at least all numbers out. But it did not work at all.</p>
  
  <pre><code>SELECT licenseplate, DATE_FORMAT(date, '%d/%m/%y'), mileage
  FROM auto_new
  WHERE LENGTH(licenseplate) = 6
  AND IsNumeric(licenseplate) = 1
  AND licenseplate NOT LIKE '%#%'
  GROUP BY licenseplate, mileage
  </code></pre>
  
  <p>At least I got license plates without #, but how do i filter all other characters?</p>