title: How can I access the table comment from a mysql table?
body: <p>How can I get <em>just</em> the table comment from a mysql table?  I tried the following, but they didn't work for various reasons.  I want to figure out how to get just the string 'my comment' (ideally via perl =)</p>
  
  <p>Any help?</p>
  
  <pre><code>-- Abbreviated output for convenience.
  SHOW TABLE STATUS WHERE Name="foo"
  +------+--------+---------+------------+------+----------------+---------------+
  | Name | Engine | Version | Row_format | Rows | Create_options | Comment       |
  +------+--------+---------+------------+------+----------------+---------------+
  | foo  | MyISAM |      10 | Fixed      |    0 |                | my comment    | 
  +------+--------+---------+------------+------+----------------+---------------+
  </code></pre>
  
  <p>and</p>
  
  <pre><code>SHOW CREATE TABLE foo;
  +-------+------------------------------------------------------------------------------+
  | Table | Create Table                                                                 |
  +-------+------------------------------------------------------------------------------+
  | fooo  | CREATE TABLE `fooo` (`id` int(11) NOT NULL PRIMARY KEY) COMMENT='my comment' | 
  +-------+------------------------------------------------------------------------------+
  </code></pre>