title: Full Text Search result similar to Mysql Like '%%' query
body: <p>We are looking for mysql query which provide result exactly <code>like '%%'</code> query but using full text search <code>MATCH AGAINST</code></p>
  
  <p>For example</p>
  
  <pre><code>Select id,name from table where jobtitle like '%java software engineer in google%'
  </code></pre>
  
  <p>It gives all rows which contain line java software engineer in google</p>
  
  <p>But if we use following mysql query then it gives a different result </p>
  
  <pre><code>Select id,name from table
  where MATCH(jobtitle) AGAINST ('+java software engineer in google' IN BOOLEAN MODE)
  </code></pre>
  
  <p>It gives rows which contain any word of from java software engineer in google</p>
  
  <p>I want the exact output which comes from using like '%java software engineer in google%' query.</p>