title: How to Bind and LIKE in Zend Framework
body: <p>I am trying to make a query where there is a bind and a LIKE.
  The query itself if I change the where for 1 works, so it is a problem of the bind and query.</p>
  
  <p>Can someone give me a hand with that:</p>
  
  <pre><code>$vendor = $this-&gt;fetchAll(
              $this-&gt;select()
                  -&gt;setIntegrityCheck(false)
                  -&gt;from('vendor', array('vendor_id'))
                  -&gt;join('user', 'vendor_user_id = user_id', array('user_id','user_name'))
                  -&gt;where("user_name LIKE (':keyword%')")
                  -&gt;limit(10)
                  -&gt;bind(array(
                      'keyword' =&gt; $keyword,
                  ))
          );
  </code></pre>
  
  <p>I am trying to get something like this for the keyword "Cake"</p>
  
  <pre><code>.
  .
  .
  WHERE user_name LIKE ('Cake%')
  LIMIT 10
  </code></pre>