title: MySql Full text Search
body: <p>In my Job listings site, I need to show jobs which have similar titles to the one which is being viewed. I am trying the following query, but its not working:</p>
  
  <pre><code>SELECT  *, 
  MATCH(title) AGAINST "Sales Coordinator" as relevance
  FROM
    jobs
  WHERE
    MATCH(title) AGAINST "Sales Coordinator"
  ORDER BY relevance DESC
  LIMIT 100
  </code></pre>
  
  <p>Also, can this be optimized, so as to give better results and maybe faster too?</p>