title: Searching full name or first or last name in MySQL database with first and last name in separate columns
body: <p>I'm working with an existing database that has first name and last name seperated in the database. I need to create a function that will take one search input and return results. say my database has a structure like....</p>
  
  <pre><code>nameFirst nameLast
  Joe       Smith
  Joe       Jones
  Joe       Brown
  </code></pre>
  
  <p>How could I, using MySql, take a search input that is say 'Joe Smith' and just get his row? But if I put just 'Joe' in the search field, return them all? Will I need to explode the string with a space? thanks!</p>