The INFORMATION_SCHEMA database has a SCHEMATA table that contains database metadata.

SELECT * FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'searching database';

The output of the SHOW DATABASES statement depends on whether you have the SHOW DATABASES privilege. It can take a LIKE clause.

SHOW DATABASES LIKE 'm%';

SHOW CREATE DATABASE shows the CREATE DATABASE statement.