LIKE operator in medoo
<p>How can i use <code>LIKE</code> operator in this sql statement using medoo framework?</p>

<p>Original SQL statement:</p>

<pre><code>SELECT id,name FROM table WHERE name LIKE %'foo'%
</code></pre>

<p>medoo statement:</p>

<pre><code>$data=$db-&gt;select('table',
    ['id','name'],
    ['AND' =&gt; ['name' =&gt; 'foo']
    ]
);
</code></pre>

<p>thanks for your help!</p>