title: how to use LIKE with conditions in sqlite or mysql with lithium recordset
body: <p>so I can look for concrete values by doing</p>
  
  <pre><code>        $recordset= Model::find('all', array(
              'conditions' =&gt; array(
                  'condition' =&gt; $somevalue
              ) 
          ))
  </code></pre>
  
  <p>however, what do I do if I want to match on a partial value?<br>
  right now, I've resorted to writing the query myself, a la: </p>
  
  <pre><code>$abc = Connections::get('default')-&gt;
     read('SELECT * FROM myTable WHERE condition LIKE "%partial string%"');
  </code></pre>