Is there any difference between in MYSQL:-
SHOW COLUMNS from XYZ;
The source of information in situations like this is the documentation
DESCRIBE is a shortcut for SHOW COLUMNS.
The DESCRIBE statement is provided for compatibility with Oracle.
Both provide means for column name pattern matching
SHOW COLUMNS FROM users LIKE '%name'; DESC users '%name';
Here is SQLFiddle demo