MySQL finds field names by field comments

Sometimes the table is too many fields, just roughly remember the table comments, want to find the field name through the field comments, you can use the following statement:

SELECT column_name,column_comment from INFORMATION_SCHEMA. Columns WHERE table_name= ' Tj_record ' and table_schema= ' tianjin_20140811 ' and column_comment like '% data valid% '

Where Table_schema is the database name. The query is as follows:

You can also find comments by field names, through the above statement.

============= View the number of fields in a table: desc tj_record syntax is: DESC table name

MySQL finds field names by field comments