COLLATIONS table provides
information about collations for each character set.
COLLATIONS table has these
The collation name.
The name of the character set with which the collation is associated.
The collation ID.
Whether the collation is the default for its character set.
Whether the character set is compiled into the server.
This is related to the amount of memory required to sort strings expressed in the character set.
SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATIONS
[WHERE COLLATION_NAME LIKE 'wild']