title: MySQL fulltext search only works in BOOLEAN Mode. How get relevancy?
body: <p>I want to search in Natural Language Mode to order results by relevancy, but my query only works with BOOLEAN Mode selector. If I use the query without BOOLEAN I get no results. Any idea why this does not work? Or idea how to get results by relevancy (most matched keywords first) with BOOELAN?</p>
  
  <p>My query:</p>
  
  <pre><code>SELECT *,
  MATCH(md.keywords) AGAINST('$meta[keywords]' IN BOOLEAN MODE) AS score
  FROM 
  meta_data AS md 
  INNER JOIN
  sites AS si ON md.domain = si.domain &amp;&amp; si.domain != '$data[domain]'
  WHERE
  MATCH(md.keywords) AGAINST('$meta[keywords]' IN BOOLEAN MODE)
  ORDER BY score Desc
  LIMIT 25
  </code></pre>
  
  <p>Database is <code>MyISAM</code> and I have altered mysql table for fulltext search</p>
  
  <pre><code>FULLTEXT KEY `title` (`title`,`description`,`keywords`)
  </code></pre>