title: sql query where like clause adding extra space in value
body: <p>I am searching a keyword in DB that is <code>Bootjack Fire and Rescue Foundation</code>
  As there is single space after a word, my query is `</p>
  
  <pre><code>WHERE `title` LIKE  '%Bootjack Fire and  Rescue Foundation%'
  </code></pre>
  
  <p>Why are there two space after the <code>and</code> keyword in the search title as you can see in the query?</p>
  
  <p><strong>add query</strong> </p>
  
  <pre><code>$keyword = 'Bootjack Fire and Rescue Foundation';
  
  $this-&gt;db-&gt;select('stores.id,store_title,store_category_id,store_sub_category_id,store_sub_category_type_id,sub_category_fourth,store_link');
  $this-&gt;db-&gt;from('stores');
  $this-&gt;db-&gt;join('users','users.id=stores.user_id');
  $this-&gt;db-&gt;join('store_category','stores.store_category_id=store_category.id');
  
  $where="`store_title` LIKE  '%".$keyword."%'";
  $this-&gt;db-&gt;where($where);
  $this-&gt;db-&gt;where('store_status', 1);
  $this-&gt;db-&gt;where('store_type', 2);
  $this-&gt;db-&gt;where('store_category.status', 1);
  $this-&gt;db-&gt;order_by('store_title','ASC');
  $this-&gt;db-&gt;order_by('store_category_id');
  </code></pre>