title: SQL full text search vs "LIKE"
body: <p>Let's say I have a fairly simple app that lets users store information on DVDs they own (title, actors, year, description, etc.) and I want to allow users to search their collection by any of these fields (e.g. "Keanu Reeves" or "The Matrix" would be valid search queries).</p>
  
  <p>What's the advantage of going with SQL full text search vs simply splitting the query up by spaces and doing a few "LIKE" clauses in the SQL statement?  Does it simply perform better or will it actually return results that are more accurate?</p>