For showing all database:
In case you need to filter database by name:
SHOW DATABASES LIKE ‘pattern’;
For complex filtering of database use WHERE Clause:
SHOW DATABASES WHERE conditions;
With WHERE clause one can use regular expressions like ‘<‘ and ‘>’ operators, string functions etc. for filtering records returned by SHOW DATABASES.