title: mysql match against query
body: <p>I am using mysql match against query in my search query like this way</p>
  
  <pre><code>MATCH(film_name) AGAINST ('the vacation' IN BOOLEAN MODE).
  </code></pre>
  
  <p>But previously i use this one </p>
  
  <pre><code>film_name like '%the vacation%'
  </code></pre>
  
  <p>So my question is that i am getting the right result now by using match and against but the problem is that when i am using like there i can use the <code>%</code> sign before and after the search string so if the search string present with in the string then it was return the result so plz tell how to write my <code>" MATCH(film_name) AGAINST ('the vacation' IN BOOLEAN MODE) "</code> so that it also behaves `like '%'.</p>
  
  <p>If the file name is 'rocketsingh'</p>
  
  <p>then if i run <code>film_name like '%rocket%'</code> then it shows me the result</p>
  
  <p>but if i run <code>MATCH(film_name) AGAINST ('rocket' IN BOOLEAN MODE)</code> then it will not show any result. Please suggest what to do.</p>