title: MySQL select rows that end in full stop/period
body: <p>I want to select all rows in a table that end in a full stop.</p>
  
  <p>When I use the following query, I get no results.</p>
  
  <pre><code>SELECT * FROM table WHERE row LIKE '%.'
  </code></pre>
  
  <p>But I know there is data in the table that ends in a full stop. </p>
  
  <p>I noticed something about the full stop causing issues in MATCH AGAINST, but that should be unrelated.</p>