title: MySQL LIKE operator Vs MATCH AGAINST
body: <p>Hi I'm worried about how to implement a simple search query, my scenario is:</p>
  <pre><code>tag VARCHAR 255
  </code></pre>
  <p>Now I need to search inside the tag field and I can use two kinds of queries:</p>
  <pre><code>  SELECT * FROM table WHERE tag LIKE '%1111%' OR LIKE '%2222%' OR LIKE '%3333%';
  </code></pre>
  <p>or</p>
  <pre><code>SELECT * ,MATCH(tag) AGAINST('+1111','+2222','+3333' IN BOOLEAN MODE) as score FROM table ORDER BY score DESC ;
  </code></pre>
  <p>Which is more accurate/precise and which is faster?</p>
  <p>Thanks</p>