title: REGEXP - Select only rows that contain letters and full stop
body: <p>I've been trying to write this query, I need to select the rows where a column has only letters (a-z) and a full stop.</p>
  
  <p>I tried this but it's not working:</p>
  
  <pre><code>SELECT * FROM table WHERE (c1 REGEXP '[^a-zA-Z\.]') = 0
  </code></pre>
  
  <p>This one would usually work in PHP.</p>