v.25.7Experimental Feature
Add functions searchAny and searchAll which are
Added functionssearchAnyandsearchAllwhich are general purpose tools to search text indexes. #80641 (Elmi Ahmadov).
Why it matters
These functions provide users with versatile and efficient tools to query text indexes by searching for any or all specified keywords, improving the flexibility and power of text search capabilities within ClickHouse.How to use it
Use the new functions<code>searchAny</code> and <code>searchAll</code> in your SQL queries to perform searches on text indexes. These functions allow searching for any matching keyword or all specified keywords respectively, enabling more refined text search queries.