title: Mysql like and BOOLEAN MODE (FULLTEXT) search
body: <p>I'm trying to write a query to search for a record using a wild card.</p>
  
  <p>I have two queries below which works but I like to know which one of the is more optimise.</p>
  
  <p>Query one does gives me what i'm looking for but query two gives me different results.</p>
  
  <p>Which one I should be using.</p>
  
  <ol>
  <li><p>Using Like in my query.</p>
  
  <pre><code>SELECT code, name
  FROM countryCounty
  WHERE name LIKE  '%County Down%'
  AND isActive =1
  AND countryISO2FK =  'GB'
  LIMIT 1
  </code></pre></li>
  <li><p>Then I have boolean mode (FULLTEXT) query.</p>
  
  <pre><code>SELECT code,name, match( name )
  AGAINST ( 'County Down' IN BOOLEAN MODE ) AS relevance
  FROM opjb_countryCounty 
  WHERE match( name ) AGAINST ( '%County Down%' IN BOOLEAN MODE ) 
      AND isActive=1 
      AND countryISO2FK='GB' 
  ORDER BY relevance DESC LIMIT 1
  </code></pre></li>
  </ol>