v.19.1New Features

Added Functions to Search for Multiple Constant Strings from Big Haystack: Multiposition, Multisearch ,firstmatch Also with -utf8, -caseinsensitive, and -caseinsensitiveutf8 Variants

Added functions to search for multiple constant strings from big haystack: multiPosition, multiSearch ,firstMatch also with -UTF8, -CaseInsensitive, and -CaseInsensitiveUTF8 variants. #4053 (Danila Kutenin)
Added new functions to search for multiple constant strings within a large text, including variants for UTF8 and case insensitivity.

Why it matters

These functions solve the problem of efficiently finding occurrences of multiple constant substrings in a large text (haystack) in a single operation, improving performance and convenience over repeated single searches.

How to use it

Use the new functions multiPosition, multiSearch, and firstMatch to search multiple constant strings at once. Variants are available with suffixes -UTF8, -CaseInsensitive, and -CaseInsensitiveUTF8 to accommodate UTF8 encoded text and case insensitive searches.