title: MySQL full text index performance issue
body: <p>I have created full-text index for one column like this 
          ALTER TABLE <code>test1</code> 
          ADD FULLTEXT INDEX <code>organizationname1</code> (<code>organizationname</code> ASC);</p>
  
  <pre><code>When I run this query 
      SELECT * FROM test1 WHERE MATCH(organizationname) AGAINST(' Limited');
      This query tack duration/ Fetch 0.061s/1.6700sec
  
  but I am using like keyword in my  query 
  
   SELECT * FROM test1 WHERE organizationname like'%Limited%'
   This query tack duration/ Fetch 0.031s/0.071sec
  
  ** Now I want to know search performance?**
  </code></pre>