跳到主要内容
跳到主要内容

MULTI_SEARCH_ALL_POSITIONS

multi_search_all_positions

Description

Syntax

ARRAY<INT> multi_search_all_positions(VARCHAR haystack, ARRAY<VARCHAR> needles)

返回一个 ARRAY,其中第 i 个元素为 needles 中第 i 个元素 needle,在字符串 haystack首次出现的位置。位置从1开始计数,0代表未找到该元素。大小写敏感

example

mysql> select multi_search_all_positions('Hello, World!', ['hello', '!', 'world']);
+----------------------------------------------------------------------+
| multi_search_all_positions('Hello, World!', ['hello', '!', 'world']) |
+----------------------------------------------------------------------+
| [0,13,0] |
+----------------------------------------------------------------------+

select multi_search_all_positions("Hello, World!", ['hello', '!', 'world', 'Hello', 'World']);
+---------------------------------------------------------------------------------------------+
| multi_search_all_positions('Hello, World!', ARRAY('hello', '!', 'world', 'Hello', 'World')) |
+---------------------------------------------------------------------------------------------+
| [0, 13, 0, 1, 8] |
+---------------------------------------------------------------------------------------------+

keywords

MULTI_SEARCH,SEARCH,POSITIONS