title: How to use like clause in code iginiter query() WITH BIND PARAMS?
body: <p>How to use like clause in code iginiter query() WITH BIND PARAMS?</p>
  
  <p>Eg:
  When I use </p>
  
  <pre><code>$query = 'SELECT mycol FROM mytable WHERE name LIKE %?';
  $name = 'foo';
  $db-&gt;this-&gt;query($query,array($name));
  //the clause generated
  //SELECT mycol FROM mytable WHERE id LIKE '%'foo'%' 
  //I expected this
  //SELECT mycol FROM mytable WHERE id LIKE '%foo'
  </code></pre>
  
  <p>I don't to put param values inside query and use like below:
  $query = 'SELECT mycol FROM mytable WHERE name LIKE '%foo';</p>
  
  <p>Also I can not use $this->db->like() function as my query consists of:
  INSERT IGNORE 
  and 
  INSERT INTO table SELECT col FROM table2;</p>
  
  <p>Please suggests?
  Thanks,</p>