title: How to use MySQL like with order by exact match first
body: <p>I'm using MySQL 5.5 so that's why I can't use FULLTEXT search so please don't suggest it.</p>
  
  <p>What I wanted to do is if user I have 5 records for example :</p>
  
  <pre><code>Amitesh
  Ami
  Amit
  Abhi
  Arun
  </code></pre>
  
  <p>and if someone searches for Ami then it should returns Ami first as exact match then Amit &amp; Amitesh</p>