title: like in where query in zend framework 2
body: <p>I am using the Zend framework 2.x and facing the problem as I have search a lot.
  I want to use the like clause in query but each time gives the errors:</p>
  
  <p>Here is my efforts:</p>
  
  <pre><code>$sql = new Sql($this-&gt;adapter);
  $select = $sql-&gt;select()-&gt;columns(
  array('user_profile_id', 'profile_login_name'))-&gt;from($this-&gt;table)-&gt;where-&gt;like(
         'profile_login_name', '%'.$strSearch.'%');
  echo $select-&gt;getSqlString(); die;
  </code></pre>
  
  <p>but this gives the error: </p>
  
  <blockquote>
    <p><b>Fatal error</b>:  Call to undefined method
    Zend\Db\Sql\Where::getSqlString() in
    <b>/var/www/YAAB/branches/admin/models/Model/UserTable.php</b> on line
    <b>131</b><br /></p>
  </blockquote>
  
  <p>I have also used the Zend\Db\Sql\Predicate but this also gives the error.</p>
  
  <p>So my question are that </p>
  
  <ol>
  <li>how to use the like clause in query in zend framework 2?</li>
  <li>What is problem in my code?</li>
  </ol>
  
  <p>Please reply soon as it is urgent.</p>