title: Postgres regex begins with ^ and ends with $ using LIKE
body: <p>Newbie question.  I'm looking for stings beginning with letter 'R'
  this works:</p>
  
  <pre><code>SELECT *
  FROM table
  WHERE column LIKE  'R%'
  </code></pre>
  
  <p>this does not</p>
  
  <pre><code>SELECT *
  FROM table
  WHERE column LIKE '^R%'
  </code></pre>
  
  <p>WHY?
  Also just curious, if I want it to end with <code>R</code>, I use the <code>$?</code></p>
  
  <pre><code>'%R$'
  </code></pre>
  
  <p>Pattern matching is not explained well here. If you know any other resources for a layman please share.  thanks
  <a href="https://www.postgresql.org/docs/9.3/static/functions-matching.html" rel="noreferrer">https://www.postgresql.org/docs/9.3/static/functions-matching.html</a></p>