title: Retrieve database table comments in CodeIgniter
body: <p>I have created a database table in PHPMyAdmin with table comments. I plan to use the table comments to store table version. I want to retrieve the table comments in CodeIgniter database mysql driver.</p>
  
  <p>I tried to execute the query via the <a href="https://ellislab.com/codeigniter/user-guide/database/queries.html" rel="nofollow">query</a> method:</p>
  
  <pre><code>SELECT table_comment FROM INFORMATION_SCHEMA.TABLES WHERE table_schema='{$table}' AND table_name='{$database}';
  </code></pre>
  
  <p>but the it returns nothing. Is there any workaround or proper way to do this?</p>
  
  <p>Thank you!</p>