title: SQL search query (using LIKE) giving priority for column
body: <p>I'm using CodeIgniter and active record. I have <code>posts</code> table:</p>
  
  <pre><code>id | title | body | accepted | deleted
  </code></pre>
  
  <p>Once user is typing a word, <code>6</code> posts matching database will be suggested if it is inside <code>title</code> or <code>body</code> of those posts.</p>
  
  <p>What I want to do is to give priority to those posts who have that phrase inside their <code>title</code> over those posts who have that only in their <code>body</code>. how to do it?</p>
  
  <pre><code>$query = $this-&gt;db-&gt;select('id,title,body')
  -&gt;from('posts')
  -&gt;where(array('accepted'=&gt;'1'))
  -&gt;where(array('deleted'=&gt;'0'))
  -&gt;like('title', $seached_text)
  -&gt;or_like('body', $seached_text)
  -&gt;limit(6)
  -&gt;order_by('title','asc'); 
  </code></pre>