v.20.10New Feature

Add SHOW DATABASES LIKE 'xxx' Feature

Official CH changelog text
Add new feature: SHOW DATABASES LIKE 'xxx'. #14521 (hexiaoting).
Added support for the SHOW DATABASES LIKE 'pattern' statement to filter database names using SQL LIKE patterns.

Why it matters

This feature allows users to list databases matching specific patterns, making it easier to find and manage subsets of databases without manually filtering results.

How to use it

Use the SHOW DATABASES LIKE 'pattern' command where 'pattern' is a SQL LIKE pattern to filter database names. For example:

SHOW DATABASES LIKE 'test%'

Related resources

PreviousNext