title: Query to select strings end with certain character
body: <p>I have a column that contains strings as:</p>
  
  <pre><code>aaa_1
  aaa_11
  </code></pre>
  
  <p>I need to query strings that ends with <code>_1</code>. I tried the following:
  select col from table where col like <code>%_1</code>;
  But the query gives me the strings that ends with <code>_1</code> and <code>_11</code>. How can I correct this ? </p>