PHP MySQL How to get table comments

PHP MySQL How to get table comments
$sql = "Show create table about";
$query =mysql_query ($sql);

How do I write the following to get the table comments?
Thank you.

------Solution--------------------
Field?

The proud frog has the answer


SELECT column_name, Data_type, column_comment
From Information_schema.columns
WHERE table_name =?

------Solution--------------------
A table comment or a field comment?
Table annotations can be used

SQL code

show table status like table name 
------ Solution--------------------
 
   
   

    
     SQL code 
    
    
show table status lik E ' table name ' 
------Solution--------------------
 The old brother is still breathing the air of nature ... 
 
 
      
       discussion  
      
 
      
 SQL Code 
      
 Show Table status like ' table name ' 
      
 
      
------solution--------------------
 
      
       discussion  
      
 
      
 The old brother is still calling
     Suck the air of nature ... 
      
 
      
 Reference: 
      
 
      
 SQL Code 
      
 Show Table status like ' table name ' 
      
 
      
 