title: How to search for obtaining the "best" result
body: <p>suppose someone enter this search (on an form):</p>
  
  <pre><code>Nicole Kidman films
  </code></pre>
  
  <p>Which SQL i can use to find "the best" results ? </p>
  
  <p>I suppose something like this : </p>
  
  <pre><code>SELECT * FROM myTable WHERE ( Field='%Nicole Kidman Films%' OR Field='%Nicole%' OR Field='%Kidman%' OR Field='%Films%' ) 
  </code></pre>
  
  <p>My question is how to get most relevant result ? 
  Thank you very much!</p>