title: searching multiple columns with one or more keywords using sql
body: <p>I have one search box that I would like to have search 6 columns in my schools database when an input is made. So far the search box searches the name field only and returns a match for exact or partial inputs. </p>
  
  <p>I would like to search for a specific city and have all results show up from the name AND city columns (instead of just the name column) and so on. </p>
  
  <p>Say I wanted to search with a zip code, I would like the listings to be all schools in that zip code. And finally if I input 2 words (e.g. penn Philadelphia) I would like all penn schools to show that are in the name column AND city column only. (not just all the penns in the name or every school in Philadelphia) and so on. These may be an elementary questions on the matter but I've been searching for days with no success. Maybe better use of wildcards and the "AND" "OR" clauses would benefit me. </p>
  
  <p>Can someone help me structure a sql query to accomplish this?</p>
  
  <p>this is what I have so far:</p>
  
  <pre><code>SELECT * FROM schools 
  WHERE (name='%name%' OR address='%name%' OR city='%name%'OR zip='%name%')
  </code></pre>