v.25.7Improvement

Highlight metacharacters in LIKE/REGEXP patterns as you

Official CH changelog text
Highlight metacharacters in LIKE/REGEXP patterns as you type. We already have it in clickhouse-format and in the echo in clickhouse-client, but now it is done in the command prompt as well. #82871 (Alexey Milovidov).
Highlight metacharacters in LIKE and REGEXP patterns interactively as you type in the ClickHouse command prompt.

Why it matters

This feature helps users visually identify special characters and syntax in pattern matching expressions, reducing errors and improving query writing efficiency during interactive sessions.

How to use it

The highlighting is enabled by default in the ClickHouse command prompt. Users simply type their LIKE or REGEXP patterns, and metacharacters will be automatically highlighted in real-time.

Related resources

PreviousNext