(doris-website) branch master updated: [enhance](function) add more explanation about regexp functions (#916)

lihaopeng Mon, 29 Jul 2024 20:15:42 -0700

This is an automated email from the ASF dual-hosted git repository.

lihaopeng pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git



The following commit(s) were added to refs/heads/master by this push:
     new 47cad09b04f [enhance](function) add more explanation about regexp 
functions (#916)
47cad09b04f is described below

commit 47cad09b04f2741d143e5f4745bdfa62d86affbe
Author: zclllhhjj <[email protected]>
AuthorDate: Tue Jul 30 11:15:29 2024 +0800

    [enhance](function) add more explanation about regexp functions (#916)
    
    1. add explanation about Chinese character matching
    2. remove all `not_regexp` docs. it's not a function.
---
 .../string-functions/regexp/not-regexp.md          | 56 ----------------------
 .../string-functions/regexp/regexp-extract-all.md  | 11 ++++-
 .../string-functions/regexp/regexp-extract.md      | 13 ++++-
 .../string-functions/regexp/regexp-replace-one.md  | 13 ++++-
 .../string-functions/regexp/regexp-replace.md      | 13 ++++-
 .../string-functions/regexp/regexp.md              | 15 ++++--
 .../string-functions/regexp/not-regexp.md          | 56 ----------------------
 .../string-functions/regexp/regexp-extract-all.md  | 11 ++++-
 .../string-functions/regexp/regexp-extract.md      | 14 +++++-
 .../string-functions/regexp/regexp-replace-one.md  | 13 ++++-
 .../string-functions/regexp/regexp-replace.md      | 13 ++++-
 .../string-functions/regexp/regexp.md              | 15 ++++--
 .../string-functions/regexp/not_regexp.md          | 56 ----------------------
 .../string-functions/regexp/regexp.md              | 17 +++++--
 .../string-functions/regexp/regexp_extract.md      | 16 +++++--
 .../string-functions/regexp/regexp_extract_all.md  | 13 ++++-
 .../string-functions/regexp/regexp_replace.md      | 15 ++++--
 .../string-functions/regexp/regexp_replace_one.md  | 15 ++++--
 .../string-functions/regexp/not-regexp.md          | 56 ----------------------
 .../string-functions/regexp/regexp-extract-all.md  | 11 ++++-
 .../string-functions/regexp/regexp-extract.md      | 14 +++++-
 .../string-functions/regexp/regexp-replace-one.md  | 13 ++++-
 .../string-functions/regexp/regexp-replace.md      | 13 ++++-
 .../string-functions/regexp/regexp.md              | 15 ++++--
 .../string-functions/regexp/not-regexp.md          | 56 ----------------------
 .../string-functions/regexp/regexp-extract-all.md  | 11 ++++-
 .../string-functions/regexp/regexp-extract.md      | 14 +++++-
 .../string-functions/regexp/regexp-replace-one.md  | 13 ++++-
 .../string-functions/regexp/regexp-replace.md      | 13 ++++-
 .../string-functions/regexp/regexp.md              | 15 ++++--
 .../string-functions/regexp/not-regexp.md          | 56 ----------------------
 .../string-functions/regexp/regexp-extract-all.md  | 11 ++++-
 .../string-functions/regexp/regexp-extract.md      | 14 +++++-
 .../string-functions/regexp/regexp-replace-one.md  | 13 ++++-
 .../string-functions/regexp/regexp-replace.md      | 13 ++++-
 .../string-functions/regexp/regexp.md              | 15 ++++--
 sidebars.json                                      |  3 +-
 .../string-functions/regexp/not_regexp.md          | 56 ----------------------
 .../string-functions/regexp/regexp.md              | 17 +++++--
 .../string-functions/regexp/regexp_extract.md      | 15 ++++--
 .../string-functions/regexp/regexp_extract_all.md  | 13 ++++-
 .../string-functions/regexp/regexp_replace.md      | 15 ++++--
 .../string-functions/regexp/regexp_replace_one.md  | 15 ++++--
 .../string-functions/regexp/not-regexp.md          | 56 ----------------------
 .../string-functions/regexp/regexp-extract-all.md  | 11 ++++-
 .../string-functions/regexp/regexp-extract.md      | 13 ++++-
 .../string-functions/regexp/regexp-replace-one.md  | 13 ++++-
 .../string-functions/regexp/regexp-replace.md      | 13 ++++-
 .../string-functions/regexp/regexp.md              | 15 ++++--
 .../string-functions/regexp/not-regexp.md          | 56 ----------------------
 .../string-functions/regexp/regexp-extract-all.md  | 11 ++++-
 .../string-functions/regexp/regexp-extract.md      | 13 ++++-
 .../string-functions/regexp/regexp-replace-one.md  | 13 ++++-
 .../string-functions/regexp/regexp-replace.md      | 13 ++++-
 .../string-functions/regexp/regexp.md              | 15 ++++--
 .../string-functions/regexp/not-regexp.md          | 56 ----------------------
 .../string-functions/regexp/regexp-extract-all.md  | 11 ++++-
 .../string-functions/regexp/regexp-extract.md      | 13 ++++-
 .../string-functions/regexp/regexp-replace-one.md  | 13 ++++-
 .../string-functions/regexp/regexp-replace.md      | 13 ++++-
 .../string-functions/regexp/regexp.md              | 15 ++++--
 versioned_sidebars/version-1.2-sidebars.json       |  3 +-
 versioned_sidebars/version-2.0-sidebars.json       |  3 +-
 versioned_sidebars/version-2.1-sidebars.json       |  3 +-
 versioned_sidebars/version-3.0-sidebars.json       |  3 +-
 65 files changed, 570 insertions(+), 680 deletions(-)

diff --git 
a/docs/sql-manual/sql-functions/string-functions/regexp/not-regexp.md 
b/docs/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
deleted file mode 100644
index facb912871a..00000000000
--- a/docs/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
+++ /dev/null
@@ -1,56 +0,0 @@
----
-{
-    "title": "NOT REGEXP",
-    "language": "en"
-}
----
-
-<!-- 
-licensed to the apache software foundation (asf) under one
-or more contributor license agreements.  see the notice file
-distributed with this work for additional information
-regarding copyright ownership.  the asf licenses this file
-to you under the apache license, version 2.0 (the
-"license"); you may not use this file except in compliance
-with the license.  you may obtain a copy of the license at
-
-  http://www.apache.org/licenses/license-2.0
-
-unless required by applicable law or agreed to in writing,
-software distributed under the license is distributed on an
-"as is" basis, without warranties or conditions of any
-kind, either express or implied.  see the license for the
-specific language governing permissions and limitations
-under the license.
--->
-
-## not regexp
-### description
-#### syntax
-
-`BOOLEAN not regexp(VARCHAR str, VARCHAR pattern)`
-
-Perform regular matching on the string str, return false if it matches, and 
return true if it doesn't match. pattern is a regular expression.
-
-### example
-
-```
-// Find all data in the k1 field that does not start with 'billie'
-mysql> select k1 from test where k1 not regexp '^billie';
-+--------------------+
-| k1                 |
-+--------------------+
-| Emmy eillish       |
-+--------------------+
-
-// Find all the data in the k1 field that does not end with 'ok':
-mysql> select k1 from test where k1 not regexp 'ok$';
-+------------+
-| k1         |
-+------------+
-| It's true  |
-+------------+
-```
-
-### keywords
-    REGEXP, NOT, NOT REGEXP
diff --git 
a/docs/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md 
b/docs/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
index a7788de8cd7..56083a78417 100644
--- 
a/docs/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
+++ 
b/docs/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
@@ -32,9 +32,11 @@ under the License.
 
 Regularly matches a string str and extracts the first sub-pattern matching 
part of pattern. The pattern needs to exactly match a part of str in order to 
return an array of strings for the part of the pattern that needs to be 
matched. If there is no match or the pattern has no sub-pattern, the empty 
string is returned.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)');
 +--------------------------------------------------------------+
 | regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)') |
@@ -55,6 +57,13 @@ mysql> SELECT regexp_extract_all('abc=111, def=222, 
ghi=333','("[^"]+"|\\w+)=("[
 
+--------------------------------------------------------------------------------+
 | ['abc','def','ghi']                                                          
  |
 
+--------------------------------------------------------------------------------+
+
+mysql> select regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)');
++------------------------------------------------------------------------------------------------+
+| regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)')       |
++------------------------------------------------------------------------------------------------+
+| ['这是一段中文']                                                                   
            |
++------------------------------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git 
a/docs/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md 
b/docs/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
index 9c567db6769..fc82934f4be 100644
--- a/docs/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
+++ b/docs/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_extract (VARCHAR str, VARCHAR pattern, int pos)`
 
-
 The string STR is matched regularly and the POS matching part which conforms 
to pattern is extracted. Patterns need to match exactly some part of the STR to 
return to the matching part of the pattern. If there is no match, return an 
empty string.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1);
 +-------------------------------------------------------------+
 | regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1) |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_extract('AbCdE', 
'([[:lower:]]+)C([[:lower:]]+)', 2);
 +-------------------------------------------------------------+
 | d                                                           |
 +-------------------------------------------------------------+
+
+mysql> select regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)', 2);
++-----------------------------------------------------------------------------------------------+
+| regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)', 2)       |
++-----------------------------------------------------------------------------------------------+
+| This is a passage in English 1234567                                         
                 |
++-----------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_EXTRACT,REGEXP,EXTRACT
diff --git 
a/docs/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md 
b/docs/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
index 8344122e4a9..138bd601529 100644
--- 
a/docs/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
+++ 
b/docs/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace_one(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 Regular matching of STR strings, replacing the part hitting pattern with repl, 
replacing only the first match.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace_one('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace_one('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace_one('a b b','(b)','<\\1>');
 +----------------------------------------+
 | a <b> b                                |
 +----------------------------------------+
+
+mysql> select regexp_replace_one('这是一段中文This is a passage in English 1234567', 
'\\p{Han}', '123');
++------------------------------------------------------------------------------------------------+
+| regexp_replace_one('这是一段中文This is a passage in English 1234567', '\p{Han}', 
'123')       |
++------------------------------------------------------------------------------------------------+
+| 123是一段中文This is a passage in English 1234567                                 
             |
++------------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE_ONE,REGEXP,REPLACE,ONE
diff --git 
a/docs/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md 
b/docs/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
index 1d5dae96bb6..7c35c1ce8c8 100644
--- a/docs/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
+++ b/docs/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 Regular matching of STR strings, replacing the part hitting pattern with repl
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace('a b c','(b)','<\\1>');
 +----------------------------------------+
 | a <b> c                                |
 +----------------------------------------+
+
+mysql> select regexp_replace('这是一段中文This is a passage in English 1234567', 
'\\p{Han}+', '123');
++---------------------------------------------------------------------------------------------+
+| regexp_replace('这是一段中文This is a passage in English 1234567', '\p{Han}+', 
'123')       |
++---------------------------------------------------------------------------------------------+
+| 123This is a passage in English 1234567                                      
               |
++---------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE,REGEXP,REPLACE
diff --git a/docs/sql-manual/sql-functions/string-functions/regexp/regexp.md 
b/docs/sql-manual/sql-functions/string-functions/regexp/regexp.md
index 3f1b362268c..3f7145197d5 100644
--- a/docs/sql-manual/sql-functions/string-functions/regexp/regexp.md
+++ b/docs/sql-manual/sql-functions/string-functions/regexp/regexp.md
@@ -32,10 +32,12 @@ under the License.
 
 Perform regular matching on the string str, return true if it matches, and 
return false if it doesn't match. pattern is a regular expression.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
-// Find all data starting with 'billie' in the k1 field
+```sql
+--- Find all data starting with 'billie' in the k1 field
 mysql> select k1 from test where k1 regexp '^billie';
 +--------------------+
 | k1                 |
@@ -43,13 +45,20 @@ mysql> select k1 from test where k1 regexp '^billie';
 | billie eillish     |
 +--------------------+
 
-// Find all data ending with 'ok' in the k1 field:
+--- Find all data ending with 'ok' in the k1 field:
 mysql> select k1 from test where k1 regexp 'ok$';
 +----------+
 | k1       |
 +----------+
 | It's ok  |
 +----------+
+
+mysql> select regexp('这是一段中文This is a passage in English 1234567', '\\p{Han}');
++-----------------------------------------------------------------------------+
+| ('这是一段中文This is a passage in English 1234567' regexp '\p{Han}')       |
++-----------------------------------------------------------------------------+
+|                                                                           1 |
++-----------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
deleted file mode 100644
index 3e9a052890f..00000000000
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
+++ /dev/null
@@ -1,56 +0,0 @@
----
-{
-    "title": "NOT REGEXP",
-    "language": "zh-CN"
-}
----
-
-<!-- 
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements.  See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership.  The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License.  You may obtain a copy of the License at
-
-  http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied.  See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## not regexp
-### description
-#### syntax
-
-`BOOLEAN not regexp(VARCHAR str, VARCHAR pattern)`
-
-对字符串 str 进行正则匹配，匹配上的则返回 false，没匹配上则返回 true。pattern 为正则表达式。
-
-### example
-
-```
-// 查找 k1 字段中不以 'billie' 为开头的所有数据
-mysql > select k1 from test where k1 not regexp '^billie';
-+--------------------+
-| k1                 |
-+--------------------+
-| Emmy eillish       |
-+--------------------+
-
-// 查找 k1 字段中不以 'ok' 为结尾的所有数据：
-mysql > select k1 from test where k1 not regexp 'ok$';
-+------------+
-| k1         |
-+------------+
-| It's true  |
-+------------+
-```
-
-### keywords
-    REGEXP, NOT, NOT REGEXP
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
index 4e3e6176baa..cfed4f5987a 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
@@ -30,9 +30,11 @@ under the License.
 
 对字符串 str 进行正则匹配，抽取符合 pattern 的第一个子模式匹配部分。需要 pattern 完全匹配 str 中的某部分，这样才能返回 
pattern 部分中需匹配部分的字符串数组。如果没有匹配或者pattern没有子模式，返回空字符串。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)');
 +--------------------------------------------------------------+
 | regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)') |
@@ -53,6 +55,13 @@ mysql> SELECT regexp_extract_all('abc=111, def=222, 
ghi=333','("[^"]+"|\\w+)=("[
 
+--------------------------------------------------------------------------------+
 | ['abc','def','ghi']                                                          
  |
 
+--------------------------------------------------------------------------------+
+
+mysql> select regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)');
++------------------------------------------------------------------------------------------------+
+| regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)')       |
++------------------------------------------------------------------------------------------------+
+| ['这是一段中文']                                                                   
            |
++------------------------------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
index 93a5e1a801b..6a9bfdff8d7 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
@@ -28,24 +28,34 @@ under the License.
 
 `VARCHAR regexp_extract(VARCHAR str, VARCHAR pattern, int pos)`
 
-
 对字符串 str 进行正则匹配，抽取符合 pattern 的第 pos 个匹配部分。需要 pattern 完全匹配 str 中的某部分，这样才能返回 
pattern 部分中需匹配部分。如果没有匹配，返回空字符串。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1);
 +-------------------------------------------------------------+
 | regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1) |
 +-------------------------------------------------------------+
 | b                                                           |
 +-------------------------------------------------------------+
+
 mysql> SELECT regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 2);
 +-------------------------------------------------------------+
 | regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 2) |
 +-------------------------------------------------------------+
 | d                                                           |
 +-------------------------------------------------------------+
+
+mysql> select regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)', 2);
++-----------------------------------------------------------------------------------------------+
+| regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)', 2)       |
++-----------------------------------------------------------------------------------------------+
+| This is a passage in English 1234567                                         
                 |
++-----------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_EXTRACT,REGEXP,EXTRACT
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
index 4603042f6d8..fb548a2213d 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace_one(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 对字符串 str 进行正则匹配, 将命中 pattern 的部分使用 repl 来进行替换，仅替换第一个匹配项。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace_one('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace_one('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace_one('a b b','(b)','<\\1>');
 +----------------------------------------+
 | a <b> b                                |
 +----------------------------------------+
+
+mysql> select regexp_replace_one('这是一段中文This is a passage in English 1234567', 
'\\p{Han}', '123');
++------------------------------------------------------------------------------------------------+
+| regexp_replace_one('这是一段中文This is a passage in English 1234567', '\p{Han}', 
'123')       |
++------------------------------------------------------------------------------------------------+
+| 123是一段中文This is a passage in English 1234567                                 
             |
++------------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE_ONE,REGEXP,REPLACE,ONE
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
index 50a14ff7a02..7679632060e 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 对字符串 str 进行正则匹配, 将命中 pattern 的部分使用 repl 来进行替换
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace('a b c','(b)','<\\1>');
 +----------------------------------------+
 | a <b> c                                |
 +----------------------------------------+
+
+mysql> select regexp_replace('这是一段中文This is a passage in English 1234567', 
'\\p{Han}+', '123');
++---------------------------------------------------------------------------------------------+
+| regexp_replace('这是一段中文This is a passage in English 1234567', '\p{Han}+', 
'123')       |
++---------------------------------------------------------------------------------------------+
+| 123This is a passage in English 1234567                                      
               |
++---------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE,REGEXP,REPLACE
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp.md
index c6000a2a122..d7eba8f923b 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/regexp/regexp.md
@@ -32,10 +32,12 @@ under the License.
 
 对字符串 str 进行正则匹配，匹配上的则返回 true，没匹配上则返回 false。pattern 为正则表达式。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
-// 查找 k1 字段中以 'billie' 为开头的所有数据
+```sql
+--- 查找 k1 字段中以 'billie' 为开头的所有数据
 mysql > select k1 from test where k1 regexp '^billie';
 +--------------------+
 | k1                 |
@@ -43,13 +45,20 @@ mysql > select k1 from test where k1 regexp '^billie';
 | billie eillish     |
 +--------------------+
 
-// 查找 k1 字段中以 'ok' 为结尾的所有数据：
+--- 查找 k1 字段中以 'ok' 为结尾的所有数据：
 mysql > select k1 from test where k1 regexp 'ok$';
 +----------+
 | k1       |
 +----------+
 | It's ok  |
 +----------+
+
+mysql> select regexp('这是一段中文This is a passage in English 1234567', '\\p{Han}');
++-----------------------------------------------------------------------------+
+| ('这是一段中文This is a passage in English 1234567' regexp '\p{Han}')       |
++-----------------------------------------------------------------------------+
+|                                                                           1 |
++-----------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/not_regexp.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/not_regexp.md
deleted file mode 100644
index 7e7bb278c5d..00000000000
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/not_regexp.md
+++ /dev/null
@@ -1,56 +0,0 @@
----
-{
-    "title": "not regexp",
-    "language": "zh-CN"
-}
----
-
-<!-- 
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements.  See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership.  The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License.  You may obtain a copy of the License at
-
-  http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied.  See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## not regexp
-### description
-#### syntax
-
-`BOOLEAN not regexp(VARCHAR str, VARCHAR pattern)`
-
-对字符串 str 进行正则匹配，匹配上的则返回 false，没匹配上则返回 true。pattern 为正则表达式。
-
-### example
-
-```
-// 查找 k1 字段中不以 'billie' 为开头的所有数据
-mysql > select k1 from test where k1 not regexp '^billie';
-+--------------------+
-| k1                 |
-+--------------------+
-| Emmy eillish       |
-+--------------------+
-
-// 查找 k1 字段中不以 'ok' 为结尾的所有数据：
-mysql > select k1 from test where k1 not regexp 'ok$';
-+------------+
-| k1         |
-+------------+
-| It's true  |
-+------------+
-```
-
-### keywords
-    REGEXP, NOT, NOT REGEXP
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp.md
index f4e690c08ce..d7eba8f923b 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp.md
@@ -1,6 +1,6 @@
 ---
 {
-    "title": "regexp",
+    "title": "REGEXP",
     "language": "zh-CN"
 }
 ---
@@ -32,10 +32,12 @@ under the License.
 
 对字符串 str 进行正则匹配，匹配上的则返回 true，没匹配上则返回 false。pattern 为正则表达式。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
-// 查找 k1 字段中以 'billie' 为开头的所有数据
+```sql
+--- 查找 k1 字段中以 'billie' 为开头的所有数据
 mysql > select k1 from test where k1 regexp '^billie';
 +--------------------+
 | k1                 |
@@ -43,13 +45,20 @@ mysql > select k1 from test where k1 regexp '^billie';
 | billie eillish     |
 +--------------------+
 
-// 查找 k1 字段中以 'ok' 为结尾的所有数据：
+--- 查找 k1 字段中以 'ok' 为结尾的所有数据：
 mysql > select k1 from test where k1 regexp 'ok$';
 +----------+
 | k1       |
 +----------+
 | It's ok  |
 +----------+
+
+mysql> select regexp('这是一段中文This is a passage in English 1234567', '\\p{Han}');
++-----------------------------------------------------------------------------+
+| ('这是一段中文This is a passage in English 1234567' regexp '\p{Han}')       |
++-----------------------------------------------------------------------------+
+|                                                                           1 |
++-----------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_extract.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_extract.md
index 275113672c6..6a9bfdff8d7 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_extract.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_extract.md
@@ -1,6 +1,6 @@
 ---
 {
-    "title": "regexp_extract",
+    "title": "REGEXP_EXTRACT",
     "language": "zh-CN"
 }
 ---
@@ -28,24 +28,34 @@ under the License.
 
 `VARCHAR regexp_extract(VARCHAR str, VARCHAR pattern, int pos)`
 
-
 对字符串 str 进行正则匹配，抽取符合 pattern 的第 pos 个匹配部分。需要 pattern 完全匹配 str 中的某部分，这样才能返回 
pattern 部分中需匹配部分。如果没有匹配，返回空字符串。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1);
 +-------------------------------------------------------------+
 | regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1) |
 +-------------------------------------------------------------+
 | b                                                           |
 +-------------------------------------------------------------+
+
 mysql> SELECT regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 2);
 +-------------------------------------------------------------+
 | regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 2) |
 +-------------------------------------------------------------+
 | d                                                           |
 +-------------------------------------------------------------+
+
+mysql> select regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)', 2);
++-----------------------------------------------------------------------------------------------+
+| regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)', 2)       |
++-----------------------------------------------------------------------------------------------+
+| This is a passage in English 1234567                                         
                 |
++-----------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_EXTRACT,REGEXP,EXTRACT
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_extract_all.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_extract_all.md
index 7d71b74bc78..cfed4f5987a 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_extract_all.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_extract_all.md
@@ -1,6 +1,6 @@
 ---
 {
-    "title": "regexp_extract_all",
+    "title": "REGEXP_EXTRACT_ALL",
     "language": "zh-CN"
 }
 ---
@@ -30,9 +30,11 @@ under the License.
 
 对字符串 str 进行正则匹配，抽取符合 pattern 的第一个子模式匹配部分。需要 pattern 完全匹配 str 中的某部分，这样才能返回 
pattern 部分中需匹配部分的字符串数组。如果没有匹配或者pattern没有子模式，返回空字符串。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)');
 +--------------------------------------------------------------+
 | regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)') |
@@ -53,6 +55,13 @@ mysql> SELECT regexp_extract_all('abc=111, def=222, 
ghi=333','("[^"]+"|\\w+)=("[
 
+--------------------------------------------------------------------------------+
 | ['abc','def','ghi']                                                          
  |
 
+--------------------------------------------------------------------------------+
+
+mysql> select regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)');
++------------------------------------------------------------------------------------------------+
+| regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)')       |
++------------------------------------------------------------------------------------------------+
+| ['这是一段中文']                                                                   
            |
++------------------------------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_replace.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_replace.md
index df3e654478f..7679632060e 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_replace.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_replace.md
@@ -1,6 +1,6 @@
 ---
 {
-    "title": "regexp_replace",
+    "title": "REGEXP_REPLACE",
     "language": "zh-CN"
 }
 ---
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 对字符串 str 进行正则匹配, 将命中 pattern 的部分使用 repl 来进行替换
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace('a b c','(b)','<\\1>');
 +----------------------------------------+
 | a <b> c                                |
 +----------------------------------------+
+
+mysql> select regexp_replace('这是一段中文This is a passage in English 1234567', 
'\\p{Han}+', '123');
++---------------------------------------------------------------------------------------------+
+| regexp_replace('这是一段中文This is a passage in English 1234567', '\p{Han}+', 
'123')       |
++---------------------------------------------------------------------------------------------+
+| 123This is a passage in English 1234567                                      
               |
++---------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE,REGEXP,REPLACE
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_replace_one.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_replace_one.md
index 0910f49b9a3..fb548a2213d 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_replace_one.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_replace_one.md
@@ -1,6 +1,6 @@
 ---
 {
-    "title": "regexp_replace_one",
+    "title": "REGEXP_REPLACE_ONE",
     "language": "zh-CN"
 }
 ---
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace_one(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 对字符串 str 进行正则匹配, 将命中 pattern 的部分使用 repl 来进行替换，仅替换第一个匹配项。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace_one('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace_one('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace_one('a b b','(b)','<\\1>');
 +----------------------------------------+
 | a <b> b                                |
 +----------------------------------------+
+
+mysql> select regexp_replace_one('这是一段中文This is a passage in English 1234567', 
'\\p{Han}', '123');
++------------------------------------------------------------------------------------------------+
+| regexp_replace_one('这是一段中文This is a passage in English 1234567', '\p{Han}', 
'123')       |
++------------------------------------------------------------------------------------------------+
+| 123是一段中文This is a passage in English 1234567                                 
             |
++------------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE_ONE,REGEXP,REPLACE,ONE
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
deleted file mode 100644
index 3e9a052890f..00000000000
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
+++ /dev/null
@@ -1,56 +0,0 @@
----
-{
-    "title": "NOT REGEXP",
-    "language": "zh-CN"
-}
----
-
-<!-- 
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements.  See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership.  The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License.  You may obtain a copy of the License at
-
-  http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied.  See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## not regexp
-### description
-#### syntax
-
-`BOOLEAN not regexp(VARCHAR str, VARCHAR pattern)`
-
-对字符串 str 进行正则匹配，匹配上的则返回 false，没匹配上则返回 true。pattern 为正则表达式。
-
-### example
-
-```
-// 查找 k1 字段中不以 'billie' 为开头的所有数据
-mysql > select k1 from test where k1 not regexp '^billie';
-+--------------------+
-| k1                 |
-+--------------------+
-| Emmy eillish       |
-+--------------------+
-
-// 查找 k1 字段中不以 'ok' 为结尾的所有数据：
-mysql > select k1 from test where k1 not regexp 'ok$';
-+------------+
-| k1         |
-+------------+
-| It's true  |
-+------------+
-```
-
-### keywords
-    REGEXP, NOT, NOT REGEXP
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
index 4e3e6176baa..cfed4f5987a 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
@@ -30,9 +30,11 @@ under the License.
 
 对字符串 str 进行正则匹配，抽取符合 pattern 的第一个子模式匹配部分。需要 pattern 完全匹配 str 中的某部分，这样才能返回 
pattern 部分中需匹配部分的字符串数组。如果没有匹配或者pattern没有子模式，返回空字符串。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)');
 +--------------------------------------------------------------+
 | regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)') |
@@ -53,6 +55,13 @@ mysql> SELECT regexp_extract_all('abc=111, def=222, 
ghi=333','("[^"]+"|\\w+)=("[
 
+--------------------------------------------------------------------------------+
 | ['abc','def','ghi']                                                          
  |
 
+--------------------------------------------------------------------------------+
+
+mysql> select regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)');
++------------------------------------------------------------------------------------------------+
+| regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)')       |
++------------------------------------------------------------------------------------------------+
+| ['这是一段中文']                                                                   
            |
++------------------------------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
index 93a5e1a801b..6a9bfdff8d7 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
@@ -28,24 +28,34 @@ under the License.
 
 `VARCHAR regexp_extract(VARCHAR str, VARCHAR pattern, int pos)`
 
-
 对字符串 str 进行正则匹配，抽取符合 pattern 的第 pos 个匹配部分。需要 pattern 完全匹配 str 中的某部分，这样才能返回 
pattern 部分中需匹配部分。如果没有匹配，返回空字符串。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1);
 +-------------------------------------------------------------+
 | regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1) |
 +-------------------------------------------------------------+
 | b                                                           |
 +-------------------------------------------------------------+
+
 mysql> SELECT regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 2);
 +-------------------------------------------------------------+
 | regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 2) |
 +-------------------------------------------------------------+
 | d                                                           |
 +-------------------------------------------------------------+
+
+mysql> select regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)', 2);
++-----------------------------------------------------------------------------------------------+
+| regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)', 2)       |
++-----------------------------------------------------------------------------------------------+
+| This is a passage in English 1234567                                         
                 |
++-----------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_EXTRACT,REGEXP,EXTRACT
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
index 4603042f6d8..fb548a2213d 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace_one(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 对字符串 str 进行正则匹配, 将命中 pattern 的部分使用 repl 来进行替换，仅替换第一个匹配项。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace_one('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace_one('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace_one('a b b','(b)','<\\1>');
 +----------------------------------------+
 | a <b> b                                |
 +----------------------------------------+
+
+mysql> select regexp_replace_one('这是一段中文This is a passage in English 1234567', 
'\\p{Han}', '123');
++------------------------------------------------------------------------------------------------+
+| regexp_replace_one('这是一段中文This is a passage in English 1234567', '\p{Han}', 
'123')       |
++------------------------------------------------------------------------------------------------+
+| 123是一段中文This is a passage in English 1234567                                 
             |
++------------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE_ONE,REGEXP,REPLACE,ONE
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
index 50a14ff7a02..7679632060e 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 对字符串 str 进行正则匹配, 将命中 pattern 的部分使用 repl 来进行替换
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace('a b c','(b)','<\\1>');
 +----------------------------------------+
 | a <b> c                                |
 +----------------------------------------+
+
+mysql> select regexp_replace('这是一段中文This is a passage in English 1234567', 
'\\p{Han}+', '123');
++---------------------------------------------------------------------------------------------+
+| regexp_replace('这是一段中文This is a passage in English 1234567', '\p{Han}+', 
'123')       |
++---------------------------------------------------------------------------------------------+
+| 123This is a passage in English 1234567                                      
               |
++---------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE,REGEXP,REPLACE
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp.md
index c6000a2a122..d7eba8f923b 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp.md
@@ -32,10 +32,12 @@ under the License.
 
 对字符串 str 进行正则匹配，匹配上的则返回 true，没匹配上则返回 false。pattern 为正则表达式。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
-// 查找 k1 字段中以 'billie' 为开头的所有数据
+```sql
+--- 查找 k1 字段中以 'billie' 为开头的所有数据
 mysql > select k1 from test where k1 regexp '^billie';
 +--------------------+
 | k1                 |
@@ -43,13 +45,20 @@ mysql > select k1 from test where k1 regexp '^billie';
 | billie eillish     |
 +--------------------+
 
-// 查找 k1 字段中以 'ok' 为结尾的所有数据：
+--- 查找 k1 字段中以 'ok' 为结尾的所有数据：
 mysql > select k1 from test where k1 regexp 'ok$';
 +----------+
 | k1       |
 +----------+
 | It's ok  |
 +----------+
+
+mysql> select regexp('这是一段中文This is a passage in English 1234567', '\\p{Han}');
++-----------------------------------------------------------------------------+
+| ('这是一段中文This is a passage in English 1234567' regexp '\p{Han}')       |
++-----------------------------------------------------------------------------+
+|                                                                           1 |
++-----------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
deleted file mode 100644
index 3e9a052890f..00000000000
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
+++ /dev/null
@@ -1,56 +0,0 @@
----
-{
-    "title": "NOT REGEXP",
-    "language": "zh-CN"
-}
----
-
-<!-- 
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements.  See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership.  The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License.  You may obtain a copy of the License at
-
-  http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied.  See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## not regexp
-### description
-#### syntax
-
-`BOOLEAN not regexp(VARCHAR str, VARCHAR pattern)`
-
-对字符串 str 进行正则匹配，匹配上的则返回 false，没匹配上则返回 true。pattern 为正则表达式。
-
-### example
-
-```
-// 查找 k1 字段中不以 'billie' 为开头的所有数据
-mysql > select k1 from test where k1 not regexp '^billie';
-+--------------------+
-| k1                 |
-+--------------------+
-| Emmy eillish       |
-+--------------------+
-
-// 查找 k1 字段中不以 'ok' 为结尾的所有数据：
-mysql > select k1 from test where k1 not regexp 'ok$';
-+------------+
-| k1         |
-+------------+
-| It's true  |
-+------------+
-```
-
-### keywords
-    REGEXP, NOT, NOT REGEXP
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
index 4e3e6176baa..cfed4f5987a 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
@@ -30,9 +30,11 @@ under the License.
 
 对字符串 str 进行正则匹配，抽取符合 pattern 的第一个子模式匹配部分。需要 pattern 完全匹配 str 中的某部分，这样才能返回 
pattern 部分中需匹配部分的字符串数组。如果没有匹配或者pattern没有子模式，返回空字符串。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)');
 +--------------------------------------------------------------+
 | regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)') |
@@ -53,6 +55,13 @@ mysql> SELECT regexp_extract_all('abc=111, def=222, 
ghi=333','("[^"]+"|\\w+)=("[
 
+--------------------------------------------------------------------------------+
 | ['abc','def','ghi']                                                          
  |
 
+--------------------------------------------------------------------------------+
+
+mysql> select regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)');
++------------------------------------------------------------------------------------------------+
+| regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)')       |
++------------------------------------------------------------------------------------------------+
+| ['这是一段中文']                                                                   
            |
++------------------------------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
index 93a5e1a801b..6a9bfdff8d7 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
@@ -28,24 +28,34 @@ under the License.
 
 `VARCHAR regexp_extract(VARCHAR str, VARCHAR pattern, int pos)`
 
-
 对字符串 str 进行正则匹配，抽取符合 pattern 的第 pos 个匹配部分。需要 pattern 完全匹配 str 中的某部分，这样才能返回 
pattern 部分中需匹配部分。如果没有匹配，返回空字符串。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1);
 +-------------------------------------------------------------+
 | regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1) |
 +-------------------------------------------------------------+
 | b                                                           |
 +-------------------------------------------------------------+
+
 mysql> SELECT regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 2);
 +-------------------------------------------------------------+
 | regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 2) |
 +-------------------------------------------------------------+
 | d                                                           |
 +-------------------------------------------------------------+
+
+mysql> select regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)', 2);
++-----------------------------------------------------------------------------------------------+
+| regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)', 2)       |
++-----------------------------------------------------------------------------------------------+
+| This is a passage in English 1234567                                         
                 |
++-----------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_EXTRACT,REGEXP,EXTRACT
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
index 4603042f6d8..fb548a2213d 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace_one(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 对字符串 str 进行正则匹配, 将命中 pattern 的部分使用 repl 来进行替换，仅替换第一个匹配项。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace_one('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace_one('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace_one('a b b','(b)','<\\1>');
 +----------------------------------------+
 | a <b> b                                |
 +----------------------------------------+
+
+mysql> select regexp_replace_one('这是一段中文This is a passage in English 1234567', 
'\\p{Han}', '123');
++------------------------------------------------------------------------------------------------+
+| regexp_replace_one('这是一段中文This is a passage in English 1234567', '\p{Han}', 
'123')       |
++------------------------------------------------------------------------------------------------+
+| 123是一段中文This is a passage in English 1234567                                 
             |
++------------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE_ONE,REGEXP,REPLACE,ONE
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
index 50a14ff7a02..7679632060e 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 对字符串 str 进行正则匹配, 将命中 pattern 的部分使用 repl 来进行替换
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace('a b c','(b)','<\\1>');
 +----------------------------------------+
 | a <b> c                                |
 +----------------------------------------+
+
+mysql> select regexp_replace('这是一段中文This is a passage in English 1234567', 
'\\p{Han}+', '123');
++---------------------------------------------------------------------------------------------+
+| regexp_replace('这是一段中文This is a passage in English 1234567', '\p{Han}+', 
'123')       |
++---------------------------------------------------------------------------------------------+
+| 123This is a passage in English 1234567                                      
               |
++---------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE,REGEXP,REPLACE
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp.md
index c6000a2a122..d7eba8f923b 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp.md
@@ -32,10 +32,12 @@ under the License.
 
 对字符串 str 进行正则匹配，匹配上的则返回 true，没匹配上则返回 false。pattern 为正则表达式。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
-// 查找 k1 字段中以 'billie' 为开头的所有数据
+```sql
+--- 查找 k1 字段中以 'billie' 为开头的所有数据
 mysql > select k1 from test where k1 regexp '^billie';
 +--------------------+
 | k1                 |
@@ -43,13 +45,20 @@ mysql > select k1 from test where k1 regexp '^billie';
 | billie eillish     |
 +--------------------+
 
-// 查找 k1 字段中以 'ok' 为结尾的所有数据：
+--- 查找 k1 字段中以 'ok' 为结尾的所有数据：
 mysql > select k1 from test where k1 regexp 'ok$';
 +----------+
 | k1       |
 +----------+
 | It's ok  |
 +----------+
+
+mysql> select regexp('这是一段中文This is a passage in English 1234567', '\\p{Han}');
++-----------------------------------------------------------------------------+
+| ('这是一段中文This is a passage in English 1234567' regexp '\p{Han}')       |
++-----------------------------------------------------------------------------+
+|                                                                           1 |
++-----------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
deleted file mode 100644
index 3e9a052890f..00000000000
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
+++ /dev/null
@@ -1,56 +0,0 @@
----
-{
-    "title": "NOT REGEXP",
-    "language": "zh-CN"
-}
----
-
-<!-- 
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements.  See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership.  The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License.  You may obtain a copy of the License at
-
-  http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied.  See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## not regexp
-### description
-#### syntax
-
-`BOOLEAN not regexp(VARCHAR str, VARCHAR pattern)`
-
-对字符串 str 进行正则匹配，匹配上的则返回 false，没匹配上则返回 true。pattern 为正则表达式。
-
-### example
-
-```
-// 查找 k1 字段中不以 'billie' 为开头的所有数据
-mysql > select k1 from test where k1 not regexp '^billie';
-+--------------------+
-| k1                 |
-+--------------------+
-| Emmy eillish       |
-+--------------------+
-
-// 查找 k1 字段中不以 'ok' 为结尾的所有数据：
-mysql > select k1 from test where k1 not regexp 'ok$';
-+------------+
-| k1         |
-+------------+
-| It's true  |
-+------------+
-```
-
-### keywords
-    REGEXP, NOT, NOT REGEXP
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
index 4e3e6176baa..cfed4f5987a 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
@@ -30,9 +30,11 @@ under the License.
 
 对字符串 str 进行正则匹配，抽取符合 pattern 的第一个子模式匹配部分。需要 pattern 完全匹配 str 中的某部分，这样才能返回 
pattern 部分中需匹配部分的字符串数组。如果没有匹配或者pattern没有子模式，返回空字符串。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)');
 +--------------------------------------------------------------+
 | regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)') |
@@ -53,6 +55,13 @@ mysql> SELECT regexp_extract_all('abc=111, def=222, 
ghi=333','("[^"]+"|\\w+)=("[
 
+--------------------------------------------------------------------------------+
 | ['abc','def','ghi']                                                          
  |
 
+--------------------------------------------------------------------------------+
+
+mysql> select regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)');
++------------------------------------------------------------------------------------------------+
+| regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)')       |
++------------------------------------------------------------------------------------------------+
+| ['这是一段中文']                                                                   
            |
++------------------------------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
index 93a5e1a801b..6a9bfdff8d7 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
@@ -28,24 +28,34 @@ under the License.
 
 `VARCHAR regexp_extract(VARCHAR str, VARCHAR pattern, int pos)`
 
-
 对字符串 str 进行正则匹配，抽取符合 pattern 的第 pos 个匹配部分。需要 pattern 完全匹配 str 中的某部分，这样才能返回 
pattern 部分中需匹配部分。如果没有匹配，返回空字符串。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1);
 +-------------------------------------------------------------+
 | regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1) |
 +-------------------------------------------------------------+
 | b                                                           |
 +-------------------------------------------------------------+
+
 mysql> SELECT regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 2);
 +-------------------------------------------------------------+
 | regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 2) |
 +-------------------------------------------------------------+
 | d                                                           |
 +-------------------------------------------------------------+
+
+mysql> select regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)', 2);
++-----------------------------------------------------------------------------------------------+
+| regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)', 2)       |
++-----------------------------------------------------------------------------------------------+
+| This is a passage in English 1234567                                         
                 |
++-----------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_EXTRACT,REGEXP,EXTRACT
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
index 4603042f6d8..fb548a2213d 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace_one(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 对字符串 str 进行正则匹配, 将命中 pattern 的部分使用 repl 来进行替换，仅替换第一个匹配项。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace_one('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace_one('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace_one('a b b','(b)','<\\1>');
 +----------------------------------------+
 | a <b> b                                |
 +----------------------------------------+
+
+mysql> select regexp_replace_one('这是一段中文This is a passage in English 1234567', 
'\\p{Han}', '123');
++------------------------------------------------------------------------------------------------+
+| regexp_replace_one('这是一段中文This is a passage in English 1234567', '\p{Han}', 
'123')       |
++------------------------------------------------------------------------------------------------+
+| 123是一段中文This is a passage in English 1234567                                 
             |
++------------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE_ONE,REGEXP,REPLACE,ONE
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
index 50a14ff7a02..7679632060e 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 对字符串 str 进行正则匹配, 将命中 pattern 的部分使用 repl 来进行替换
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace('a b c','(b)','<\\1>');
 +----------------------------------------+
 | a <b> c                                |
 +----------------------------------------+
+
+mysql> select regexp_replace('这是一段中文This is a passage in English 1234567', 
'\\p{Han}+', '123');
++---------------------------------------------------------------------------------------------+
+| regexp_replace('这是一段中文This is a passage in English 1234567', '\p{Han}+', 
'123')       |
++---------------------------------------------------------------------------------------------+
+| 123This is a passage in English 1234567                                      
               |
++---------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE,REGEXP,REPLACE
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp.md
 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp.md
index c6000a2a122..d7eba8f923b 100644
--- 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp.md
+++ 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp.md
@@ -32,10 +32,12 @@ under the License.
 
 对字符串 str 进行正则匹配，匹配上的则返回 true，没匹配上则返回 false。pattern 为正则表达式。
 
+字符集匹配需要使用 Unicode 标准字符类型。例如，匹配中文请使用 `\p{Han}`。
+
 ### example
 
-```
-// 查找 k1 字段中以 'billie' 为开头的所有数据
+```sql
+--- 查找 k1 字段中以 'billie' 为开头的所有数据
 mysql > select k1 from test where k1 regexp '^billie';
 +--------------------+
 | k1                 |
@@ -43,13 +45,20 @@ mysql > select k1 from test where k1 regexp '^billie';
 | billie eillish     |
 +--------------------+
 
-// 查找 k1 字段中以 'ok' 为结尾的所有数据：
+--- 查找 k1 字段中以 'ok' 为结尾的所有数据：
 mysql > select k1 from test where k1 regexp 'ok$';
 +----------+
 | k1       |
 +----------+
 | It's ok  |
 +----------+
+
+mysql> select regexp('这是一段中文This is a passage in English 1234567', '\\p{Han}');
++-----------------------------------------------------------------------------+
+| ('这是一段中文This is a passage in English 1234567' regexp '\p{Han}')       |
++-----------------------------------------------------------------------------+
+|                                                                           1 |
++-----------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git a/sidebars.json b/sidebars.json
index b8fbb21c611..5ab70c0cb21 100644
--- a/sidebars.json
+++ b/sidebars.json
@@ -854,8 +854,7 @@
                                         
"sql-manual/sql-functions/string-functions/regexp/regexp-extract",
                                         
"sql-manual/sql-functions/string-functions/regexp/regexp-extract-all",
                                         
"sql-manual/sql-functions/string-functions/regexp/regexp-replace",
-                                        
"sql-manual/sql-functions/string-functions/regexp/regexp-replace-one",
-                                        
"sql-manual/sql-functions/string-functions/regexp/not-regexp"
+                                        
"sql-manual/sql-functions/string-functions/regexp/regexp-replace-one"
                                     ]
                                 }
                             ]
diff --git 
a/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/not_regexp.md
 
b/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/not_regexp.md
deleted file mode 100644
index c5d267568da..00000000000
--- 
a/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/not_regexp.md
+++ /dev/null
@@ -1,56 +0,0 @@
----
-{
-    "title": "not regexp",
-    "language": "en"
-}
----
-
-<!-- 
-licensed to the apache software foundation (asf) under one
-or more contributor license agreements.  see the notice file
-distributed with this work for additional information
-regarding copyright ownership.  the asf licenses this file
-to you under the apache license, version 2.0 (the
-"license"); you may not use this file except in compliance
-with the license.  you may obtain a copy of the license at
-
-  http://www.apache.org/licenses/license-2.0
-
-unless required by applicable law or agreed to in writing,
-software distributed under the license is distributed on an
-"as is" basis, without warranties or conditions of any
-kind, either express or implied.  see the license for the
-specific language governing permissions and limitations
-under the license.
--->
-
-## not regexp
-### description
-#### syntax
-
-`BOOLEAN not regexp(VARCHAR str, VARCHAR pattern)`
-
-Perform regular matching on the string str, return false if it matches, and 
return true if it doesn't match. pattern is a regular expression.
-
-### example
-
-```
-// Find all data in the k1 field that does not start with 'billie'
-mysql> select k1 from test where k1 not regexp '^billie';
-+--------------------+
-| k1                 |
-+--------------------+
-| Emmy eillish       |
-+--------------------+
-
-// Find all the data in the k1 field that does not end with 'ok':
-mysql> select k1 from test where k1 not regexp 'ok$';
-+------------+
-| k1         |
-+------------+
-| It's true  |
-+------------+
-```
-
-### keywords
-    REGEXP, NOT, NOT REGEXP
diff --git 
a/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp.md
 
b/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp.md
index 0f0b1d338c9..3f7145197d5 100644
--- 
a/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp.md
+++ 
b/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp.md
@@ -1,6 +1,6 @@
 ---
 {
-    "title": "regexp",
+    "title": "REGEXP",
     "language": "en"
 }
 ---
@@ -32,10 +32,12 @@ under the License.
 
 Perform regular matching on the string str, return true if it matches, and 
return false if it doesn't match. pattern is a regular expression.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
-// Find all data starting with 'billie' in the k1 field
+```sql
+--- Find all data starting with 'billie' in the k1 field
 mysql> select k1 from test where k1 regexp '^billie';
 +--------------------+
 | k1                 |
@@ -43,13 +45,20 @@ mysql> select k1 from test where k1 regexp '^billie';
 | billie eillish     |
 +--------------------+
 
-// Find all data ending with 'ok' in the k1 field:
+--- Find all data ending with 'ok' in the k1 field:
 mysql> select k1 from test where k1 regexp 'ok$';
 +----------+
 | k1       |
 +----------+
 | It's ok  |
 +----------+
+
+mysql> select regexp('这是一段中文This is a passage in English 1234567', '\\p{Han}');
++-----------------------------------------------------------------------------+
+| ('这是一段中文This is a passage in English 1234567' regexp '\p{Han}')       |
++-----------------------------------------------------------------------------+
+|                                                                           1 |
++-----------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git 
a/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_extract.md
 
b/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_extract.md
index ffc4d5423d1..fc82934f4be 100644
--- 
a/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_extract.md
+++ 
b/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_extract.md
@@ -1,6 +1,6 @@
 ---
 {
-    "title": "regexp_extract",
+    "title": "REGEXP_EXTRACT",
     "language": "en"
 }
 ---
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_extract (VARCHAR str, VARCHAR pattern, int pos)`
 
-
 The string STR is matched regularly and the POS matching part which conforms 
to pattern is extracted. Patterns need to match exactly some part of the STR to 
return to the matching part of the pattern. If there is no match, return an 
empty string.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1);
 +-------------------------------------------------------------+
 | regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1) |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_extract('AbCdE', 
'([[:lower:]]+)C([[:lower:]]+)', 2);
 +-------------------------------------------------------------+
 | d                                                           |
 +-------------------------------------------------------------+
+
+mysql> select regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)', 2);
++-----------------------------------------------------------------------------------------------+
+| regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)', 2)       |
++-----------------------------------------------------------------------------------------------+
+| This is a passage in English 1234567                                         
                 |
++-----------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_EXTRACT,REGEXP,EXTRACT
diff --git 
a/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_extract_all.md
 
b/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_extract_all.md
index 7cfc6320c41..56083a78417 100644
--- 
a/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_extract_all.md
+++ 
b/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_extract_all.md
@@ -1,6 +1,6 @@
 ---
 {
-    "title": "regexp_extract_all",
+    "title": "REGEXP_EXTRACT_ALL",
     "language": "en"
 }
 ---
@@ -32,9 +32,11 @@ under the License.
 
 Regularly matches a string str and extracts the first sub-pattern matching 
part of pattern. The pattern needs to exactly match a part of str in order to 
return an array of strings for the part of the pattern that needs to be 
matched. If there is no match or the pattern has no sub-pattern, the empty 
string is returned.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)');
 +--------------------------------------------------------------+
 | regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)') |
@@ -55,6 +57,13 @@ mysql> SELECT regexp_extract_all('abc=111, def=222, 
ghi=333','("[^"]+"|\\w+)=("[
 
+--------------------------------------------------------------------------------+
 | ['abc','def','ghi']                                                          
  |
 
+--------------------------------------------------------------------------------+
+
+mysql> select regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)');
++------------------------------------------------------------------------------------------------+
+| regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)')       |
++------------------------------------------------------------------------------------------------+
+| ['这是一段中文']                                                                   
            |
++------------------------------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git 
a/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_replace.md
 
b/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_replace.md
index 05ec3777b84..7c35c1ce8c8 100644
--- 
a/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_replace.md
+++ 
b/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_replace.md
@@ -1,6 +1,6 @@
 ---
 {
-    "title": "regexp_replace",
+    "title": "REGEXP_REPLACE",
     "language": "en"
 }
 ---
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 Regular matching of STR strings, replacing the part hitting pattern with repl
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace('a b c','(b)','<\\1>');
 +----------------------------------------+
 | a <b> c                                |
 +----------------------------------------+
+
+mysql> select regexp_replace('这是一段中文This is a passage in English 1234567', 
'\\p{Han}+', '123');
++---------------------------------------------------------------------------------------------+
+| regexp_replace('这是一段中文This is a passage in English 1234567', '\p{Han}+', 
'123')       |
++---------------------------------------------------------------------------------------------+
+| 123This is a passage in English 1234567                                      
               |
++---------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE,REGEXP,REPLACE
diff --git 
a/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_replace_one.md
 
b/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_replace_one.md
index 9bc7347955e..138bd601529 100644
--- 
a/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_replace_one.md
+++ 
b/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/regexp/regexp_replace_one.md
@@ -1,6 +1,6 @@
 ---
 {
-    "title": "regexp_replace_one",
+    "title": "REGEXP_REPLACE_ONE",
     "language": "en"
 }
 ---
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace_one(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 Regular matching of STR strings, replacing the part hitting pattern with repl, 
replacing only the first match.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace_one('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace_one('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace_one('a b b','(b)','<\\1>');
 +----------------------------------------+
 | a <b> b                                |
 +----------------------------------------+
+
+mysql> select regexp_replace_one('这是一段中文This is a passage in English 1234567', 
'\\p{Han}', '123');
++------------------------------------------------------------------------------------------------+
+| regexp_replace_one('这是一段中文This is a passage in English 1234567', '\p{Han}', 
'123')       |
++------------------------------------------------------------------------------------------------+
+| 123是一段中文This is a passage in English 1234567                                 
             |
++------------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE_ONE,REGEXP,REPLACE,ONE
diff --git 
a/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
 
b/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
deleted file mode 100644
index facb912871a..00000000000
--- 
a/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
+++ /dev/null
@@ -1,56 +0,0 @@
----
-{
-    "title": "NOT REGEXP",
-    "language": "en"
-}
----
-
-<!-- 
-licensed to the apache software foundation (asf) under one
-or more contributor license agreements.  see the notice file
-distributed with this work for additional information
-regarding copyright ownership.  the asf licenses this file
-to you under the apache license, version 2.0 (the
-"license"); you may not use this file except in compliance
-with the license.  you may obtain a copy of the license at
-
-  http://www.apache.org/licenses/license-2.0
-
-unless required by applicable law or agreed to in writing,
-software distributed under the license is distributed on an
-"as is" basis, without warranties or conditions of any
-kind, either express or implied.  see the license for the
-specific language governing permissions and limitations
-under the license.
--->
-
-## not regexp
-### description
-#### syntax
-
-`BOOLEAN not regexp(VARCHAR str, VARCHAR pattern)`
-
-Perform regular matching on the string str, return false if it matches, and 
return true if it doesn't match. pattern is a regular expression.
-
-### example
-
-```
-// Find all data in the k1 field that does not start with 'billie'
-mysql> select k1 from test where k1 not regexp '^billie';
-+--------------------+
-| k1                 |
-+--------------------+
-| Emmy eillish       |
-+--------------------+
-
-// Find all the data in the k1 field that does not end with 'ok':
-mysql> select k1 from test where k1 not regexp 'ok$';
-+------------+
-| k1         |
-+------------+
-| It's true  |
-+------------+
-```
-
-### keywords
-    REGEXP, NOT, NOT REGEXP
diff --git 
a/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
 
b/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
index a7788de8cd7..56083a78417 100644
--- 
a/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
+++ 
b/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
@@ -32,9 +32,11 @@ under the License.
 
 Regularly matches a string str and extracts the first sub-pattern matching 
part of pattern. The pattern needs to exactly match a part of str in order to 
return an array of strings for the part of the pattern that needs to be 
matched. If there is no match or the pattern has no sub-pattern, the empty 
string is returned.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)');
 +--------------------------------------------------------------+
 | regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)') |
@@ -55,6 +57,13 @@ mysql> SELECT regexp_extract_all('abc=111, def=222, 
ghi=333','("[^"]+"|\\w+)=("[
 
+--------------------------------------------------------------------------------+
 | ['abc','def','ghi']                                                          
  |
 
+--------------------------------------------------------------------------------+
+
+mysql> select regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)');
++------------------------------------------------------------------------------------------------+
+| regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)')       |
++------------------------------------------------------------------------------------------------+
+| ['这是一段中文']                                                                   
            |
++------------------------------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git 
a/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
 
b/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
index 9c567db6769..fc82934f4be 100644
--- 
a/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
+++ 
b/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_extract (VARCHAR str, VARCHAR pattern, int pos)`
 
-
 The string STR is matched regularly and the POS matching part which conforms 
to pattern is extracted. Patterns need to match exactly some part of the STR to 
return to the matching part of the pattern. If there is no match, return an 
empty string.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1);
 +-------------------------------------------------------------+
 | regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1) |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_extract('AbCdE', 
'([[:lower:]]+)C([[:lower:]]+)', 2);
 +-------------------------------------------------------------+
 | d                                                           |
 +-------------------------------------------------------------+
+
+mysql> select regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)', 2);
++-----------------------------------------------------------------------------------------------+
+| regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)', 2)       |
++-----------------------------------------------------------------------------------------------+
+| This is a passage in English 1234567                                         
                 |
++-----------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_EXTRACT,REGEXP,EXTRACT
diff --git 
a/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
 
b/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
index 8344122e4a9..138bd601529 100644
--- 
a/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
+++ 
b/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace_one(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 Regular matching of STR strings, replacing the part hitting pattern with repl, 
replacing only the first match.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace_one('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace_one('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace_one('a b b','(b)','<\\1>');
 +----------------------------------------+
 | a <b> b                                |
 +----------------------------------------+
+
+mysql> select regexp_replace_one('这是一段中文This is a passage in English 1234567', 
'\\p{Han}', '123');
++------------------------------------------------------------------------------------------------+
+| regexp_replace_one('这是一段中文This is a passage in English 1234567', '\p{Han}', 
'123')       |
++------------------------------------------------------------------------------------------------+
+| 123是一段中文This is a passage in English 1234567                                 
             |
++------------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE_ONE,REGEXP,REPLACE,ONE
diff --git 
a/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
 
b/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
index 1d5dae96bb6..7c35c1ce8c8 100644
--- 
a/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
+++ 
b/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 Regular matching of STR strings, replacing the part hitting pattern with repl
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace('a b c','(b)','<\\1>');
 +----------------------------------------+
 | a <b> c                                |
 +----------------------------------------+
+
+mysql> select regexp_replace('这是一段中文This is a passage in English 1234567', 
'\\p{Han}+', '123');
++---------------------------------------------------------------------------------------------+
+| regexp_replace('这是一段中文This is a passage in English 1234567', '\p{Han}+', 
'123')       |
++---------------------------------------------------------------------------------------------+
+| 123This is a passage in English 1234567                                      
               |
++---------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE,REGEXP,REPLACE
diff --git 
a/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp.md
 
b/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp.md
index 3f1b362268c..3f7145197d5 100644
--- 
a/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp.md
+++ 
b/versioned_docs/version-2.0/sql-manual/sql-functions/string-functions/regexp/regexp.md
@@ -32,10 +32,12 @@ under the License.
 
 Perform regular matching on the string str, return true if it matches, and 
return false if it doesn't match. pattern is a regular expression.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
-// Find all data starting with 'billie' in the k1 field
+```sql
+--- Find all data starting with 'billie' in the k1 field
 mysql> select k1 from test where k1 regexp '^billie';
 +--------------------+
 | k1                 |
@@ -43,13 +45,20 @@ mysql> select k1 from test where k1 regexp '^billie';
 | billie eillish     |
 +--------------------+
 
-// Find all data ending with 'ok' in the k1 field:
+--- Find all data ending with 'ok' in the k1 field:
 mysql> select k1 from test where k1 regexp 'ok$';
 +----------+
 | k1       |
 +----------+
 | It's ok  |
 +----------+
+
+mysql> select regexp('这是一段中文This is a passage in English 1234567', '\\p{Han}');
++-----------------------------------------------------------------------------+
+| ('这是一段中文This is a passage in English 1234567' regexp '\p{Han}')       |
++-----------------------------------------------------------------------------+
+|                                                                           1 |
++-----------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git 
a/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
 
b/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
deleted file mode 100644
index facb912871a..00000000000
--- 
a/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
+++ /dev/null
@@ -1,56 +0,0 @@
----
-{
-    "title": "NOT REGEXP",
-    "language": "en"
-}
----
-
-<!-- 
-licensed to the apache software foundation (asf) under one
-or more contributor license agreements.  see the notice file
-distributed with this work for additional information
-regarding copyright ownership.  the asf licenses this file
-to you under the apache license, version 2.0 (the
-"license"); you may not use this file except in compliance
-with the license.  you may obtain a copy of the license at
-
-  http://www.apache.org/licenses/license-2.0
-
-unless required by applicable law or agreed to in writing,
-software distributed under the license is distributed on an
-"as is" basis, without warranties or conditions of any
-kind, either express or implied.  see the license for the
-specific language governing permissions and limitations
-under the license.
--->
-
-## not regexp
-### description
-#### syntax
-
-`BOOLEAN not regexp(VARCHAR str, VARCHAR pattern)`
-
-Perform regular matching on the string str, return false if it matches, and 
return true if it doesn't match. pattern is a regular expression.
-
-### example
-
-```
-// Find all data in the k1 field that does not start with 'billie'
-mysql> select k1 from test where k1 not regexp '^billie';
-+--------------------+
-| k1                 |
-+--------------------+
-| Emmy eillish       |
-+--------------------+
-
-// Find all the data in the k1 field that does not end with 'ok':
-mysql> select k1 from test where k1 not regexp 'ok$';
-+------------+
-| k1         |
-+------------+
-| It's true  |
-+------------+
-```
-
-### keywords
-    REGEXP, NOT, NOT REGEXP
diff --git 
a/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
 
b/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
index a7788de8cd7..56083a78417 100644
--- 
a/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
+++ 
b/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
@@ -32,9 +32,11 @@ under the License.
 
 Regularly matches a string str and extracts the first sub-pattern matching 
part of pattern. The pattern needs to exactly match a part of str in order to 
return an array of strings for the part of the pattern that needs to be 
matched. If there is no match or the pattern has no sub-pattern, the empty 
string is returned.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)');
 +--------------------------------------------------------------+
 | regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)') |
@@ -55,6 +57,13 @@ mysql> SELECT regexp_extract_all('abc=111, def=222, 
ghi=333','("[^"]+"|\\w+)=("[
 
+--------------------------------------------------------------------------------+
 | ['abc','def','ghi']                                                          
  |
 
+--------------------------------------------------------------------------------+
+
+mysql> select regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)');
++------------------------------------------------------------------------------------------------+
+| regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)')       |
++------------------------------------------------------------------------------------------------+
+| ['这是一段中文']                                                                   
            |
++------------------------------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git 
a/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
 
b/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
index 9c567db6769..fc82934f4be 100644
--- 
a/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
+++ 
b/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_extract (VARCHAR str, VARCHAR pattern, int pos)`
 
-
 The string STR is matched regularly and the POS matching part which conforms 
to pattern is extracted. Patterns need to match exactly some part of the STR to 
return to the matching part of the pattern. If there is no match, return an 
empty string.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1);
 +-------------------------------------------------------------+
 | regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1) |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_extract('AbCdE', 
'([[:lower:]]+)C([[:lower:]]+)', 2);
 +-------------------------------------------------------------+
 | d                                                           |
 +-------------------------------------------------------------+
+
+mysql> select regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)', 2);
++-----------------------------------------------------------------------------------------------+
+| regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)', 2)       |
++-----------------------------------------------------------------------------------------------+
+| This is a passage in English 1234567                                         
                 |
++-----------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_EXTRACT,REGEXP,EXTRACT
diff --git 
a/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
 
b/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
index 8344122e4a9..138bd601529 100644
--- 
a/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
+++ 
b/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace_one(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 Regular matching of STR strings, replacing the part hitting pattern with repl, 
replacing only the first match.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace_one('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace_one('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace_one('a b b','(b)','<\\1>');
 +----------------------------------------+
 | a <b> b                                |
 +----------------------------------------+
+
+mysql> select regexp_replace_one('这是一段中文This is a passage in English 1234567', 
'\\p{Han}', '123');
++------------------------------------------------------------------------------------------------+
+| regexp_replace_one('这是一段中文This is a passage in English 1234567', '\p{Han}', 
'123')       |
++------------------------------------------------------------------------------------------------+
+| 123是一段中文This is a passage in English 1234567                                 
             |
++------------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE_ONE,REGEXP,REPLACE,ONE
diff --git 
a/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
 
b/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
index 1d5dae96bb6..7c35c1ce8c8 100644
--- 
a/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
+++ 
b/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 Regular matching of STR strings, replacing the part hitting pattern with repl
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace('a b c','(b)','<\\1>');
 +----------------------------------------+
 | a <b> c                                |
 +----------------------------------------+
+
+mysql> select regexp_replace('这是一段中文This is a passage in English 1234567', 
'\\p{Han}+', '123');
++---------------------------------------------------------------------------------------------+
+| regexp_replace('这是一段中文This is a passage in English 1234567', '\p{Han}+', 
'123')       |
++---------------------------------------------------------------------------------------------+
+| 123This is a passage in English 1234567                                      
               |
++---------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE,REGEXP,REPLACE
diff --git 
a/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp.md
 
b/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp.md
index 3f1b362268c..3f7145197d5 100644
--- 
a/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp.md
+++ 
b/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/regexp/regexp.md
@@ -32,10 +32,12 @@ under the License.
 
 Perform regular matching on the string str, return true if it matches, and 
return false if it doesn't match. pattern is a regular expression.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
-// Find all data starting with 'billie' in the k1 field
+```sql
+--- Find all data starting with 'billie' in the k1 field
 mysql> select k1 from test where k1 regexp '^billie';
 +--------------------+
 | k1                 |
@@ -43,13 +45,20 @@ mysql> select k1 from test where k1 regexp '^billie';
 | billie eillish     |
 +--------------------+
 
-// Find all data ending with 'ok' in the k1 field:
+--- Find all data ending with 'ok' in the k1 field:
 mysql> select k1 from test where k1 regexp 'ok$';
 +----------+
 | k1       |
 +----------+
 | It's ok  |
 +----------+
+
+mysql> select regexp('这是一段中文This is a passage in English 1234567', '\\p{Han}');
++-----------------------------------------------------------------------------+
+| ('这是一段中文This is a passage in English 1234567' regexp '\p{Han}')       |
++-----------------------------------------------------------------------------+
+|                                                                           1 |
++-----------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git 
a/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
 
b/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
deleted file mode 100644
index facb912871a..00000000000
--- 
a/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/not-regexp.md
+++ /dev/null
@@ -1,56 +0,0 @@
----
-{
-    "title": "NOT REGEXP",
-    "language": "en"
-}
----
-
-<!-- 
-licensed to the apache software foundation (asf) under one
-or more contributor license agreements.  see the notice file
-distributed with this work for additional information
-regarding copyright ownership.  the asf licenses this file
-to you under the apache license, version 2.0 (the
-"license"); you may not use this file except in compliance
-with the license.  you may obtain a copy of the license at
-
-  http://www.apache.org/licenses/license-2.0
-
-unless required by applicable law or agreed to in writing,
-software distributed under the license is distributed on an
-"as is" basis, without warranties or conditions of any
-kind, either express or implied.  see the license for the
-specific language governing permissions and limitations
-under the license.
--->
-
-## not regexp
-### description
-#### syntax
-
-`BOOLEAN not regexp(VARCHAR str, VARCHAR pattern)`
-
-Perform regular matching on the string str, return false if it matches, and 
return true if it doesn't match. pattern is a regular expression.
-
-### example
-
-```
-// Find all data in the k1 field that does not start with 'billie'
-mysql> select k1 from test where k1 not regexp '^billie';
-+--------------------+
-| k1                 |
-+--------------------+
-| Emmy eillish       |
-+--------------------+
-
-// Find all the data in the k1 field that does not end with 'ok':
-mysql> select k1 from test where k1 not regexp 'ok$';
-+------------+
-| k1         |
-+------------+
-| It's true  |
-+------------+
-```
-
-### keywords
-    REGEXP, NOT, NOT REGEXP
diff --git 
a/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
 
b/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
index a7788de8cd7..56083a78417 100644
--- 
a/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
+++ 
b/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract-all.md
@@ -32,9 +32,11 @@ under the License.
 
 Regularly matches a string str and extracts the first sub-pattern matching 
part of pattern. The pattern needs to exactly match a part of str in order to 
return an array of strings for the part of the pattern that needs to be 
matched. If there is no match or the pattern has no sub-pattern, the empty 
string is returned.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)');
 +--------------------------------------------------------------+
 | regexp_extract_all('AbCdE', '([[:lower:]]+)C([[:lower:]]+)') |
@@ -55,6 +57,13 @@ mysql> SELECT regexp_extract_all('abc=111, def=222, 
ghi=333','("[^"]+"|\\w+)=("[
 
+--------------------------------------------------------------------------------+
 | ['abc','def','ghi']                                                          
  |
 
+--------------------------------------------------------------------------------+
+
+mysql> select regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)');
++------------------------------------------------------------------------------------------------+
+| regexp_extract_all('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)')       |
++------------------------------------------------------------------------------------------------+
+| ['这是一段中文']                                                                   
            |
++------------------------------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git 
a/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
 
b/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
index 9c567db6769..fc82934f4be 100644
--- 
a/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
+++ 
b/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-extract.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_extract (VARCHAR str, VARCHAR pattern, int pos)`
 
-
 The string STR is matched regularly and the POS matching part which conforms 
to pattern is extracted. Patterns need to match exactly some part of the STR to 
return to the matching part of the pattern. If there is no match, return an 
empty string.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1);
 +-------------------------------------------------------------+
 | regexp_extract('AbCdE', '([[:lower:]]+)C([[:lower:]]+)', 1) |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_extract('AbCdE', 
'([[:lower:]]+)C([[:lower:]]+)', 2);
 +-------------------------------------------------------------+
 | d                                                           |
 +-------------------------------------------------------------+
+
+mysql> select regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\\p{Han}+)(.+)', 2);
++-----------------------------------------------------------------------------------------------+
+| regexp_extract('这是一段中文This is a passage in English 1234567', 
'(\p{Han}+)(.+)', 2)       |
++-----------------------------------------------------------------------------------------------+
+| This is a passage in English 1234567                                         
                 |
++-----------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_EXTRACT,REGEXP,EXTRACT
diff --git 
a/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
 
b/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
index 8344122e4a9..138bd601529 100644
--- 
a/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
+++ 
b/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace-one.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace_one(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 Regular matching of STR strings, replacing the part hitting pattern with repl, 
replacing only the first match.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace_one('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace_one('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace_one('a b b','(b)','<\\1>');
 +----------------------------------------+
 | a <b> b                                |
 +----------------------------------------+
+
+mysql> select regexp_replace_one('这是一段中文This is a passage in English 1234567', 
'\\p{Han}', '123');
++------------------------------------------------------------------------------------------------+
+| regexp_replace_one('这是一段中文This is a passage in English 1234567', '\p{Han}', 
'123')       |
++------------------------------------------------------------------------------------------------+
+| 123是一段中文This is a passage in English 1234567                                 
             |
++------------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE_ONE,REGEXP,REPLACE,ONE
diff --git 
a/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
 
b/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
index 1d5dae96bb6..7c35c1ce8c8 100644
--- 
a/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
+++ 
b/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp-replace.md
@@ -30,12 +30,13 @@ under the License.
 
 `VARCHAR regexp_replace(VARCHAR str, VARCHAR pattern, VARCHAR repl)`
 
-
 Regular matching of STR strings, replacing the part hitting pattern with repl
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
+```sql
 mysql> SELECT regexp_replace('a b c', " ", "-");
 +-----------------------------------+
 | regexp_replace('a b c', ' ', '-') |
@@ -49,6 +50,14 @@ mysql> SELECT regexp_replace('a b c','(b)','<\\1>');
 +----------------------------------------+
 | a <b> c                                |
 +----------------------------------------+
+
+mysql> select regexp_replace('这是一段中文This is a passage in English 1234567', 
'\\p{Han}+', '123');
++---------------------------------------------------------------------------------------------+
+| regexp_replace('这是一段中文This is a passage in English 1234567', '\p{Han}+', 
'123')       |
++---------------------------------------------------------------------------------------------+
+| 123This is a passage in English 1234567                                      
               |
++---------------------------------------------------------------------------------------------+
 ```
+
 ### keywords
     REGEXP_REPLACE,REGEXP,REPLACE
diff --git 
a/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp.md
 
b/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp.md
index 3f1b362268c..3f7145197d5 100644
--- 
a/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp.md
+++ 
b/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/regexp/regexp.md
@@ -32,10 +32,12 @@ under the License.
 
 Perform regular matching on the string str, return true if it matches, and 
return false if it doesn't match. pattern is a regular expression.
 
+Character set matching requires the use of Unicode standard character classes. 
For example, to match Chinese, use `\p{Han}`.
+
 ### example
 
-```
-// Find all data starting with 'billie' in the k1 field
+```sql
+--- Find all data starting with 'billie' in the k1 field
 mysql> select k1 from test where k1 regexp '^billie';
 +--------------------+
 | k1                 |
@@ -43,13 +45,20 @@ mysql> select k1 from test where k1 regexp '^billie';
 | billie eillish     |
 +--------------------+
 
-// Find all data ending with 'ok' in the k1 field:
+--- Find all data ending with 'ok' in the k1 field:
 mysql> select k1 from test where k1 regexp 'ok$';
 +----------+
 | k1       |
 +----------+
 | It's ok  |
 +----------+
+
+mysql> select regexp('这是一段中文This is a passage in English 1234567', '\\p{Han}');
++-----------------------------------------------------------------------------+
+| ('这是一段中文This is a passage in English 1234567' regexp '\p{Han}')       |
++-----------------------------------------------------------------------------+
+|                                                                           1 |
++-----------------------------------------------------------------------------+
 ```
 
 ### keywords
diff --git a/versioned_sidebars/version-1.2-sidebars.json 
b/versioned_sidebars/version-1.2-sidebars.json
index 480112e6eae..e0cd7dd9396 100644
--- a/versioned_sidebars/version-1.2-sidebars.json
+++ b/versioned_sidebars/version-1.2-sidebars.json
@@ -497,8 +497,7 @@
                                         
"sql-manual/sql-functions/string-functions/regexp/regexp_extract",
                                         
"sql-manual/sql-functions/string-functions/regexp/regexp_extract_all",
                                         
"sql-manual/sql-functions/string-functions/regexp/regexp_replace",
-                                        
"sql-manual/sql-functions/string-functions/regexp/regexp_replace_one",
-                                        
"sql-manual/sql-functions/string-functions/regexp/not_regexp"
+                                        
"sql-manual/sql-functions/string-functions/regexp/regexp_replace_one"
                                     ]
                                 }
                             ]
diff --git a/versioned_sidebars/version-2.0-sidebars.json 
b/versioned_sidebars/version-2.0-sidebars.json
index 73a006297b5..b52101471a5 100644
--- a/versioned_sidebars/version-2.0-sidebars.json
+++ b/versioned_sidebars/version-2.0-sidebars.json
@@ -769,8 +769,7 @@
                                         
"sql-manual/sql-functions/string-functions/regexp/regexp-extract",
                                         
"sql-manual/sql-functions/string-functions/regexp/regexp-extract-all",
                                         
"sql-manual/sql-functions/string-functions/regexp/regexp-replace",
-                                        
"sql-manual/sql-functions/string-functions/regexp/regexp-replace-one",
-                                        
"sql-manual/sql-functions/string-functions/regexp/not-regexp"
+                                        
"sql-manual/sql-functions/string-functions/regexp/regexp-replace-one"
                                     ]
                                 }
                             ]
diff --git a/versioned_sidebars/version-2.1-sidebars.json 
b/versioned_sidebars/version-2.1-sidebars.json
index 493b506b648..2cda90a0d18 100644
--- a/versioned_sidebars/version-2.1-sidebars.json
+++ b/versioned_sidebars/version-2.1-sidebars.json
@@ -812,8 +812,7 @@
                                         
"sql-manual/sql-functions/string-functions/regexp/regexp-extract",
                                         
"sql-manual/sql-functions/string-functions/regexp/regexp-extract-all",
                                         
"sql-manual/sql-functions/string-functions/regexp/regexp-replace",
-                                        
"sql-manual/sql-functions/string-functions/regexp/regexp-replace-one",
-                                        
"sql-manual/sql-functions/string-functions/regexp/not-regexp"
+                                        
"sql-manual/sql-functions/string-functions/regexp/regexp-replace-one"
                                     ]
                                 }
                             ]
diff --git a/versioned_sidebars/version-3.0-sidebars.json 
b/versioned_sidebars/version-3.0-sidebars.json
index c4c49299885..8c138ad1560 100644
--- a/versioned_sidebars/version-3.0-sidebars.json
+++ b/versioned_sidebars/version-3.0-sidebars.json
@@ -840,8 +840,7 @@
                                         
"sql-manual/sql-functions/string-functions/regexp/regexp-extract",
                                         
"sql-manual/sql-functions/string-functions/regexp/regexp-extract-all",
                                         
"sql-manual/sql-functions/string-functions/regexp/regexp-replace",
-                                        
"sql-manual/sql-functions/string-functions/regexp/regexp-replace-one",
-                                        
"sql-manual/sql-functions/string-functions/regexp/not-regexp"
+                                        
"sql-manual/sql-functions/string-functions/regexp/regexp-replace-one"
                                     ]
                                 }
                             ]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

(doris-website) branch master updated: [enhance](function) add more explanation about regexp functions (#916)

Reply via email to