SHOW COLUMNS FROM <tablename> gives all the information of the columns in a table, except Comments.

How to extract Comments information? I know the way to extract the information from INFORMATION SCHEMA, but how to combine the result in a single result set?

Originally asked by: Starx on Stack Overflow