title: MySql SHOW query in ZEND
body: <p>In zend it is written like</p>
  
  <pre><code>$table = $this-&gt;getTable();
          $select = $table-&gt;select()-&gt;where('status = ?',1)
                                  -&gt;where('columnOne= ?', 1) 
                                  -&gt;order('columnTwo')
                                  -&gt;limit(1);
  </code></pre>
  
  <p>similar to where, order, limit conditions how can I condition for <code>LIKE</code>?</p>
  
  <p><strong>My query is</strong></p>
  
  <blockquote>
    <p><strong><code>SHOW TABLE STATUS LIKE 'tableName'</code></strong></p>
  </blockquote>
  
  <p>I tried in this way  </p>
  
  <pre><code>    $table = $this-&gt;getTable();
                  $query= $table-&gt;select("TABLE STATUS")
                                  -&gt;like($table);
      $id = mysql_query($query);
  </code></pre>
  
  <p>then I found that no method for <code>LIKE</code> is available in ZEND.
  Then How can I write above query in Zend framerk?</p>
  
  <p>Thanks in advance.</p>