Return order of MySQL SHOW COLUMNS
- by rich
Hey guys.
Simple one this, but one I can't seem to find any information on so here goes.
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, preferable by choosing to order the results ascending alphabetically. I have had no luck with using ORDER BY Field.
Any ideas?
Cheers!