v.23.3New Feature

Added REGEXP Operator for MySQL Compatibility

Official CH changelog text
Added operator REGEXP (similar to operators "LIKE", "IN", "MOD" etc.) for better compatibility with MySQL #47869 (Robert Schulze).
Added the REGEXP operator to ClickHouse, providing regular expression matching capabilities similar to MySQL.

Why it matters

This feature enhances compatibility with MySQL by introducing the REGEXP operator, allowing users to perform pattern matching using regular expressions. It simplifies porting MySQL queries to ClickHouse and expands query expressiveness.

How to use it

Use the REGEXP operator in WHERE clauses or other expressions to match strings against regular expressions, e.g., SELECT * FROM table WHERE column REGEXP 'pattern'.

Related resources

PreviousNext