How to query column comments in Mysql?

To inquire about the comments of table fields, you can use the following SQL statement:

SHOW FULL COLUMNS FROM 表名;

For example, to retrieve the field comments for a table named users:

SHOW FULL COLUMNS FROM users;

This statement will return detailed information about all fields of the users table, including field name, data type, extra attributes, default value, whether it is NULL, key type, and field comments.