title: How to get highest matching records first of select query mysql
body: <p>Please do not down rate my question, because i'm new to MySQL. My Question is;</p>
  
  <p>I have a table named <code>'item'</code>, and it has <code>'id'</code>, <code>'timestamp'</code>, <code>'title'</code> columns.
  consider the table has following records in above order(id, timestamp, title).</p>
  
  <pre><code>100, 2016-01-12 12:26:30, sony bravia 32" Lcd TV
  
  103, 2016-01-12 12:27:30, PSP 2 sony brand new
  
  108, 2016-01-12 12:28:30, Xperia Aqua M2 brand new Sony mobile phone
  </code></pre>
  
  <p>Help me to create an SQL query to search <code>'title'</code> column that shows results as highest matching records first.</p>
  
  <blockquote>
    <p>As example, if we search <code>"new Sony xperia phone"</code> it should return
    results as following order.</p>
  </blockquote>
  
  <pre><code>108, 2016-01-12 12:28:30, Xperia Aqua M2 brand new Sony mobile phone
  
  103, 2016-01-12 12:27:30, PSP 2 sony brand new
  
  100, 2016-01-12 12:26:30, sony bravia 32" Lcd TV
  </code></pre>
  
  <blockquote>
    <p>Because highest matching record should come first.</p>
  </blockquote>
  
  <p>108, 2016-01-12 12:28:30, <code>Xperia</code> Aqua M2 brand <code>new</code> <code>Sony</code> mobile <code>phone</code></p>
  
  <p>103, 2016-01-12 12:27:30, PSP 2 <code>sony</code> brand <code>new</code></p>
  
  <p>100, 2016-01-12 12:26:30, <code>sony</code> bravia 32" Lcd TV</p>