title: reversing SQL wildcard direction
body: <p>When comparing a string to entries in the database, the _ or % wildcards allow you to search for strings in the database that contain the searchterm. But can you reverse this, such that you look for database entries that are contained within the search term?</p>
  
  <p>i.e.</p>
  
  <pre><code>SELECT Species FROM Animal WHERE Species LIKE 'horse_'
  
  returns: horse, horses
  </code></pre>
  
  <p>how would you modify this to return both values if your original term was "horses" rather than "horse"?</p>
  
  <pre><code>SELECT Species FROM Animal WHERE Species_ LIKE 'horses'
  -&gt; invalid sql syntax
  </code></pre>