Mega Code Archive

 

Categories / MySQL / Command Mysql

 

Add a LIKE clause at the end of a SHOW statement to display information only for column names that match a given pattern

SHOW COLUMNS FROM president LIKE '%name';