title: MySQL - Search One field for Multiple Values
body: <p>Tablename: tbl_person<br/>
  Columns: id,name,bio</p>
  
  <p>Sample Data: (id,name,bio)<br/>
  1,Mike,Cambridge university degree in physics<br/>
  2,Pete,Cambridge university degree in geology<br/>
  3,Sam,Oxford university degree in geology</p>
  
  <p>Problem:
  I would like to create a (My'SQL') search that can take multiple values and search and match them in one column</p>
  
  <p>Example:<br/>
  specifically search for: cambridge geology<br/>
  I would like it to return record 2,Pete<br/>
  and not all the record (because they contain matching keywords cambridge,geology)</p>
  
  <p>The search that I have so far is<br/>
  <strong>SELECT</strong> * <strong>FROM</strong> tbl_person <strong>WHERE</strong> tbl_person.bio <strong>IN</strong> ('cambridge','geology')<br/>
   --Now this does not return a match--<br/>
  Any Ideas please</p>