Several SHOW statements have been extended to allow a WHERE clause: | |
| |
The WHERE clause is evaluated against the column names displayed by the SHOW statement. | |
SHOW CHARACTER SET; | |
SHOW CHARACTER SET WHERE `Default collation` LIKE '%japanese%'; | |
This statement displays the multi-byte character sets: | |
SHOW CHARACTER SET WHERE Maxlen > 1; |