title: SQL LIKE % inside array
body: <p>I know how to perform an SQL LIKE % query for a single value like so:</p>
  
  <pre><code>SELECT * FROM users WHERE name LIKE %tom%;
  </code></pre>
  
  <p>but how do I do this if the search terms for my LIKE comes from an array? For example, let's say we have an array like this:</p>
  
  <pre><code>$words = array("Tom", "Smith", "Larry");
  </code></pre>
  
  <p>How do I perform my SQL LIKE % to search for the words in my array like:</p>
  
  <pre><code>SELECT * FROM users WHERE name LIKE %[each_element_from_my_array]%
  </code></pre>
  
  <p>WITHOUT putting the whole query inside a foreach loop or something</p>
  
  <p><strong>EDIT</strong> : I forgot to mention that I'm doing this in cakePHP inside the conditions of the cakePHP find('all') method, so that complicates things a little bit.</p>
  
  <p>Thanks</p>