title: How to select rows from a table where a word appears? (MySQL + PHP)
body: <p>I have to make a search for keywords as part of my Computer Science work.</p>
  
  <p>I have the names and descriptions of several DVD's. </p>
  
  <p>The user has to search a word, and then displayed are all the names of DVD's where the word appeared in either the title or description.</p>
  
  <p>Let's say my columns in my table
   were "dvd title" and "description", and the word the person has entered is $keyword.</p>
  
  <p>How would i select rows in mysql where $keyword appears at least once in either columns "dvd title" and "description".</p>
  
  <p>Thanks for reading. Any help appreciated. </p>