title: finding exact strings with sql like statement
body: <p>I have the following statement</p>
  
  <pre><code>SELECT *
  FROM   Delivery_Note this_
  WHERE  mycol like '%[126]%'
  </code></pre>
  
  <p>I've noticed this also returns rows that contain [123]. What is the best way to find exact matching in a string.</p>
  
  <p><em>edit</em>
  I appreciate this is not an efficient query. There a few other reasons for this approach.   </p>