从表中显示多个选定字段的列

Question

How do I Show columns for specific fields .

SHOW COLUMNS FROM core_banking_mpesa WHERE FIELD= 'id' , FIELD ='LineNo' , FIELD ='Comments'

Answer 1

Your error is that WHERE column1='val', column2='val' is not valid syntax.

You could use IN() to select the fields:

SHOW COLUMNS FROM core_banking_mpesa
WHERE FIELD IN('id','LineNo','Comments')

Or use OR:

SHOW COLUMNS FROM core_banking_mpesa
WHERE FIELD='id' OR FIELD='LineNo' OR FIELD='Comments'