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,firstMatchalso with-UTF8,-CaseInsensitive, and-CaseInsensitiveUTF8variants. #4053 (Danila Kutenin)
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 functionsmultiPosition, 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.