morrySnow commented on code in PR #1948:
URL: https://github.com/apache/doris-website/pull/1948#discussion_r1944474196
##########
docs/sql-manual/sql-functions/scalar-functions/string-functions/multi-match-any.md:
##########
@@ -24,31 +24,41 @@ specific language governing permissions and limitations
under the License.
-->
-## multi_match_any
-### Description
-#### Syntax
+## Description
-`TINYINT multi_match_any(VARCHAR haystack, ARRAY<VARCHAR> patterns)`
+Returns whether the string matches any of the given regular expressions.
+## Syntax
-Checks whether the string `haystack` matches the regular expressions
`patterns` in re2 syntax. returns 0 if none of the regular expressions are
matched and 1 if any of the patterns matches.
+```sql
+TINYINT multi_match_any(VARCHAR haystack, ARRAY<VARCHAR> patterns)
Review Comment:
1. 不用参数类型和返回类型
2. 函数名大写
3. 参数需要尖括号包裹
```suggestion
MULTI_MATCH_ANY(<haystack>, <patterns>)
```
##########
docs/sql-manual/sql-functions/scalar-functions/string-functions/multi-match-any.md:
##########
@@ -24,31 +24,41 @@ specific language governing permissions and limitations
under the License.
-->
-## multi_match_any
-### Description
-#### Syntax
+## Description
-`TINYINT multi_match_any(VARCHAR haystack, ARRAY<VARCHAR> patterns)`
+Returns whether the string matches any of the given regular expressions.
+## Syntax
-Checks whether the string `haystack` matches the regular expressions
`patterns` in re2 syntax. returns 0 if none of the regular expressions are
matched and 1 if any of the patterns matches.
+```sql
+TINYINT multi_match_any(VARCHAR haystack, ARRAY<VARCHAR> patterns)
+```
-### example
+## Parameters
-```
-mysql> select multi_match_any('Hello, World!', ['hello', '!', 'world']);
+| Parameter | Description |
+| -- | -- |
+| `haystack` | The string to be checked |
+| `patterns` | Array of regular expressions |
Review Comment:
```suggestion
| `<haystack>` | The string to be checked |
| `<patterns>` | Array of regular expressions |
```
##########
docs/sql-manual/sql-functions/scalar-functions/string-functions/multi-match-any.md:
##########
@@ -24,31 +24,41 @@ specific language governing permissions and limitations
under the License.
-->
-## multi_match_any
-### Description
-#### Syntax
+## Description
-`TINYINT multi_match_any(VARCHAR haystack, ARRAY<VARCHAR> patterns)`
+Returns whether the string matches any of the given regular expressions.
+## Syntax
-Checks whether the string `haystack` matches the regular expressions
`patterns` in re2 syntax. returns 0 if none of the regular expressions are
matched and 1 if any of the patterns matches.
+```sql
+TINYINT multi_match_any(VARCHAR haystack, ARRAY<VARCHAR> patterns)
+```
-### example
+## Parameters
-```
-mysql> select multi_match_any('Hello, World!', ['hello', '!', 'world']);
+| Parameter | Description |
+| -- | -- |
+| `haystack` | The string to be checked |
+| `patterns` | Array of regular expressions |
+
+## Return Value
+
+Returns 1 if the string `haystack` matches any of the regular expressions in
the `patterns` array, otherwise returns 0.
Review Comment:
```suggestion
Returns 1 if the string `<haystack>` matches any of the regular expressions
in the `<patterns>` array, otherwise returns 0.
```
##########
docs/sql-manual/sql-functions/scalar-functions/string-functions/multi-match-any.md:
##########
@@ -24,31 +24,41 @@ specific language governing permissions and limitations
under the License.
-->
-## multi_match_any
-### Description
-#### Syntax
+## Description
-`TINYINT multi_match_any(VARCHAR haystack, ARRAY<VARCHAR> patterns)`
+Returns whether the string matches any of the given regular expressions.
+## Syntax
-Checks whether the string `haystack` matches the regular expressions
`patterns` in re2 syntax. returns 0 if none of the regular expressions are
matched and 1 if any of the patterns matches.
+```sql
+TINYINT multi_match_any(VARCHAR haystack, ARRAY<VARCHAR> patterns)
+```
-### example
+## Parameters
-```
-mysql> select multi_match_any('Hello, World!', ['hello', '!', 'world']);
+| Parameter | Description |
+| -- | -- |
+| `haystack` | The string to be checked |
+| `patterns` | Array of regular expressions |
+
+## Return Value
+
+Returns 1 if the string `haystack` matches any of the regular expressions in
the `patterns` array, otherwise returns 0.
+
+## Examples
+
+```sql
+mysql> SELECT multi_match_any('Hello, World!', ['hello', '!', 'world']);
Review Comment:
不要prompt
```suggestion
SELECT multi_match_any('Hello, World!', ['hello', '!', 'world']);
```
##########
docs/sql-manual/sql-functions/scalar-functions/string-functions/multi-match-any.md:
##########
@@ -24,31 +24,41 @@ specific language governing permissions and limitations
under the License.
-->
-## multi_match_any
-### Description
-#### Syntax
+## Description
-`TINYINT multi_match_any(VARCHAR haystack, ARRAY<VARCHAR> patterns)`
+Returns whether the string matches any of the given regular expressions.
+## Syntax
-Checks whether the string `haystack` matches the regular expressions
`patterns` in re2 syntax. returns 0 if none of the regular expressions are
matched and 1 if any of the patterns matches.
+```sql
+TINYINT multi_match_any(VARCHAR haystack, ARRAY<VARCHAR> patterns)
+```
-### example
+## Parameters
-```
-mysql> select multi_match_any('Hello, World!', ['hello', '!', 'world']);
+| Parameter | Description |
+| -- | -- |
+| `haystack` | The string to be checked |
+| `patterns` | Array of regular expressions |
+
+## Return Value
+
+Returns 1 if the string `haystack` matches any of the regular expressions in
the `patterns` array, otherwise returns 0.
+
+## Examples
+
+```sql
+mysql> SELECT multi_match_any('Hello, World!', ['hello', '!', 'world']);
+-----------------------------------------------------------+
| multi_match_any('Hello, World!', ['hello', '!', 'world']) |
+-----------------------------------------------------------+
| 1 |
+-----------------------------------------------------------+
Review Comment:
结果和查询分开放到两个 code block 中，结果使用 text 格式
````
```text
+-----------------------------------------------------------+
| multi_match_any('Hello, World!', ['hello', '!', 'world']) |
+-----------------------------------------------------------+
| 1 |
+-----------------------------------------------------------+
```
````
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
