title: How to use a LIKE query with CodeIgniter?
body: <p>I want to run a query like this:</p>
  
  <pre><code>SELECT * FROM table WHERE field LIKE '%search_term%'
  </code></pre>
  
  <p>In CI you can bind parameters to queries, if you used <code>field=?</code> but this does not work for <code>field LIKE "%?%"</code>. From debugging output it seems the query used is <code>field LIKE "%'search'%"</code>.</p>
  
  <p>Is there an alternative way to do searching in CodeIgniter?</p>