title: How to make a sql search query more powerful?
body: <p>I wrote this sql query to search in a table:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT * FROM TableName WHERE Name LIKE '%spa%'
  </code></pre>
  
  <p>The table contain these row for example:</p>
  
  <ol>
  <li>Space Company.</li>
  <li>Spa resort.    </li>
  <li>Spa hotel.    </li>
  <li>Spare Parts.    </li>
  <li>WithoutTheKeyword.</li>
  </ol>
  
  <p>I want to know how to edit this query so it return the results sorted like this:</p>
  
  <blockquote>
    <p>2 Spa resort</p>
    
    <p>3 Spa hotel</p>
    
    <p>1 Space Company</p>
    
    <p>4 Spare Parts</p>
  </blockquote>
  
  <p>Means the items which contain the exact word first then the like ones.</p>