v.19.16New Feature

Add New Functions That Return the Array of All Matched Indices in Multimatch Family of Functions

Add new functions that return the Array of all matched indices in multiMatch family of functions. #7299 (Danila Kutenin)
Added new functions in the multiMatch family that return an array of all matched indices instead of just one match.

Why it matters

These functions address the need to retrieve all positions where the match occurs within a multi-pattern search instead of a single match, enabling more comprehensive analysis of matching data in arrays or strings.

How to use it

Use the new multiMatch functions that return arrays by calling them similarly to existing multiMatch functions, but expecting an array output with all matched indices. These functions can be directly used in SQL queries where multiple matches and their positions are required.