title: Search a whole table in mySQL for a string
body: <p>I'm trying to search a whole table in mySQL for a string. </p>
  
  <p>I want to search all fields and all entrees of a table, returning each full entry that contains the specified text.</p>
  
  <p>I can't figure out how to search multiple fields easily; here are the details:</p>
  
  <p>The table is "clients". It has about 30 fields and 800 entries, too much to show all at once in a browser. I would like to search for a name (i.e. "Mary"), but it could be in the <code>shipping_name field</code> or the <code>billing_name field</code>, or the <code>email</code> field, etc. </p>
  
  <p>I would like to search all fields for any entries that contain the string "Mary". This is what I think should work but doesn't:</p>
  
  <pre><code>SELECT * FROM `clients` IN 'Mary'
  </code></pre>