title: MySql MyIsam table with fulltext search wildcard
body: <p>I created two tables with two different storage engines with same columns:
  table1(id,col1,col2) MyIsam
  table2(id,col1,col2) innodb
  every table contain according 1700000 </p>
  
  <p>I created full text index for (col1,col2) in the 2 tables
  I have 2 keywords that I need to extract results containing them:
  'school' and 'bus'
  I am using wildcard to extract them
  select * from table1 where match(col1,col2) against ('+scho*+bus*')</p>
  
  <ul>
  <li>mean complete truncated word</li>
  <li>mean and</li>
  </ul>
  
  <p>in table1(MyIsam) the result is incorrect,
  26573 total, Query took 0.0009 sec
  rows contain any keyword 'school' or 'bus'</p>
  
  <p>in table2(innodb) the result is correct, 
  369 total, Query took 0.0420 sec
  rows contain the two words 'school' and 'bus'</p>
  
  <p>anyone can help me?</p>