title: How to properly search for data in a MySQL table
body: <p>I have table in MySQL called movie like this</p>
  
  <pre><code>id    movie_name      movie_description
  1   the godfather    The_godfather_description
  2   the dark Knight  the_dark_knight_description
  3   batman begins    batman_begins_description
  4   Inception        Inception_description
  </code></pre>
  
  <p>When the query comes I am searching like this for each word in query</p>
  
  <pre><code>select movie_name,movie_description from movie where movie_name like(%is%) or movie_description like('%is%')
      select movie_name,movie_description from movie where movie_name like(%god%) or movie_description like('%god%')
     select movie_name,movie_description from movie where movie_name like(%father%) or movie_description like('%father%')
  </code></pre>
  
  <p>Can you tell me proper way to search database so that words like 'is' and 'the' get ignored.  I also want the most relevant articles on top.</p>