title: FullText search in laravel 5
body: <p>I have query regarding fulltext search in laravel.</p>
  
  <p>I applied index in various columns.</p>
  
  <p>I have one keyword </p>
  
  <blockquote>
    <p>bar soap</p>
  </blockquote>
  
  <p>now i need record in following sequence.  </p>
  
  <ul>
  <li>bar soap</li>
  <li>soap bar</li>
  <li>bar</li>
  <li>soap</li>
  </ul>
  
  <p>My query is here</p>
  
  <pre><code>select `inventories`.*, MATCH (title, short_description, brand, long_description, inventory_code, product_code) AGAINST ('bar soap' IN BOOLEAN MODE) as score from `inventories` where MATCH (title, short_description, brand, long_description, inventory_code, product_code) AGAINST ('bar soap' IN BOOLEAN MODE) order by `score` desc
  </code></pre>
  
  <p>I have also review this <a href="https://dev.mysql.com/doc/refman/5.6/en/fulltext-boolean.html" rel="nofollow noreferrer">doc</a>.</p>
  
  <p>Your help would be appreciate.</p>