SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA; SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME ='information_schema'; # First statement for comparison SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME LIKE 'information_schema%'; # Second statement for comparison SELECT DISTINCT(TABLE_SCHEMA) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'information_schema';