title: Getting extra space in Codeigniter like query
body: <p>My code is </p>
  
  <pre>
  
      $this->db->like('postcoderegion','Brighton And Hove');
  
      $query = $this->db->get('postcode');
  
      $result = $query->result();
  
  </pre>
  
  <p>Mysql query </p>
  
  <pre>
  
      SELECT * FROM `postcode` WHERE  postcoderegion  LIKE '%Brighton And  Hove%' ESCAPE '!' 
  
  </pre>
  
  <p>When i see mysql query then i got an extra space between 'AND' or 'Hove'. Please let me know how can i remove this extra space. when i not set Hove then it not produced any space.</p>