MySQL: Showing Databases

SHOW DATABASES; 

SHOW SCHEMAS;

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| testdatabase2      |
| testdb1            |
+--------------------+
6 rows in set (0.00 sec)

SHOW DATABASES \G

*************************** 1. row ***************************
Database: information_schema
*************************** 2. row ***************************
Database: mysql
*************************** 3. row ***************************
Database: performance_schema
*************************** 4. row ***************************
Database: sys
*************************** 5. row ***************************
Database: testdatabase2
*************************** 6. row ***************************
Database: testdb1
6 rows in set (0.01 sec)

SHOW DATABASES LIKE 'test%';

+------------------+
| Database (test%) |
+------------------+
| testdatabase2    |
| testdb1          |
+------------------+
2 rows in set (0.00 sec)

show databases like '%schema';

+--------------------+
| Database (%schema) |
+--------------------+
| information_schema |
| performance_schema |
+--------------------+
2 rows in set (0.00 sec)