title: Order SQL by strongest LIKE?
body: <p>I have the following query:</p>
  
  <pre><code>SELECT * FROM table_name
  WHERE (col_1 LIKE '%$keyword%'
      OR col_2 LIKE '%$keyword%'
      OR col_3 LIKE '%$keyword%')
    AND .... &lt;some optional filters&gt; ... 
  </code></pre>
  
  <p>is there a strategy to sort based on the most relevant results?</p>