title: Performance of querying for a string that starts and ends with something
body: <p>Are there any performance difference in querying a database for some character column starting with something and ending with something?  </p>
  
  <pre><code>SELECT * FROM table WHERE column like '%something'
  SELECT * FROM table WHERE column like 'something%'
  </code></pre>
  
  <p>Any downsides to choose one approach instead of another? Disregarding the user need for matching the start or end of a word.<br>
  The way it is implemented maybe the algorithms differ in some way?</p>