退货表mysql,MySQL SHOW COLUMNS的退货顺序

I need to find the columns in a specific table, which is no problem:

SHOW COLUMNS FROM tablename LIKE '%ColumnPrefix%';

But I need to know what order they will be returned, preferably by choosing to order the results ascending alphabetically. I have had no luck with using ORDER BY.

Any ideas?

解决方案

You can query the table INFORMATION_SCHEMA.COLUMNS to get the information that SHOW COLUMNS gives you, plus it allows you to use ORDER BY or any other SQL syntax you might want to use:

SELECT COLUMN_NAME

FROM INFORMATION_SCHEMA.COLUMNS

WHERE table_name = 'tablename'

AND column_name LIKE 'ColumnPrefix%'

ORDER BY column_name