This is an automated email from the ASF dual-hosted git repository.
jiafengzheng 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 fd2b8840b8d [docs](function)Optimized string function doc (#114)
fd2b8840b8d is described below
commit fd2b8840b8d22475493b9be7bc46a688dfad78bd
Author: zy-kkk <zhong...@qq.com>
AuthorDate: Mon Sep 26 12:45:31 2022 +0800
[docs](function)Optimized string function doc (#114)
* Optimized string function doc
---
.../append_trailing_char_if_absent.md | 2 +-
.../sql-functions/string-functions/ascii.md | 2 +-
.../sql-functions/string-functions/bit_length.md | 2 +-
.../sql-functions/string-functions/char_length.md | 2 +-
.../sql-functions/string-functions/concat.md | 2 +-
.../sql-functions/string-functions/concat_ws.md | 2 +-
.../sql-functions/string-functions/ends_with.md | 2 +-
.../sql-functions/string-functions/find_in_set.md | 2 +-
.../sql-functions/string-functions/hex.md | 2 +-
.../sql-functions/string-functions/instr.md | 2 +-
.../sql-functions/string-functions/lcase.md | 2 +-
.../sql-functions/string-functions/left.md | 2 +-
.../sql-functions/string-functions/length.md | 2 +-
.../sql-functions/string-functions/like/like.md | 2 +-
.../string-functions/like/not_like.md | 2 +-
.../sql-functions/string-functions/locate.md | 2 +-
.../sql-functions/string-functions/lower.md | 2 +-
.../sql-functions/string-functions/lpad.md | 2 +-
.../sql-functions/string-functions/ltrim.md | 2 +-
.../sql-functions/string-functions/money_format.md | 2 +-
.../string-functions/null_or_empty.md | 2 +-
.../string-functions/{reverse.md => parse_url.md} | 32 +++++++-----------
.../string-functions/regexp/not_regexp.md | 2 +-
.../string-functions/regexp/regexp.md | 2 +-
.../string-functions/regexp/regexp_extract.md | 2 +-
.../string-functions/regexp/regexp_replace.md | 2 +-
.../sql-functions/string-functions/repeat.md | 2 +-
.../sql-functions/string-functions/replace.md | 2 +-
.../sql-functions/string-functions/reverse.md | 2 +-
.../sql-functions/string-functions/right.md | 2 +-
.../sql-functions/string-functions/rpad.md | 2 +-
.../sql-functions/string-functions/rtrim.md | 24 ++++++-------
.../sql-functions/string-functions/split_part.md | 2 +-
.../sql-functions/string-functions/starts_with.md | 2 +-
.../sql-functions/string-functions/strleft.md | 2 +-
.../sql-functions/string-functions/strright.md | 2 +-
.../sql-functions/string-functions/substring.md | 2 +-
.../sql-functions/string-functions/trim.md | 22 ++++++------
.../string-functions/{lcase.md => ucase.md} | 12 +++----
.../sql-functions/string-functions/unhex.md | 2 +-
.../string-functions/{lower.md => upper.md} | 18 +++++-----
.../append_trailing_char_if_absent.md | 2 +-
.../sql-functions/string-functions/ascii.md | 2 +-
.../sql-functions/string-functions/bit_length.md | 2 +-
.../sql-functions/string-functions/char_length.md | 4 +--
.../sql-functions/string-functions/concat.md | 2 +-
.../sql-functions/string-functions/concat_ws.md | 2 +-
.../sql-functions/string-functions/ends_with.md | 2 +-
.../sql-functions/string-functions/find_in_set.md | 2 +-
.../sql-functions/string-functions/hex.md | 2 +-
.../sql-functions/string-functions/instr.md | 2 +-
.../sql-functions/string-functions/lcase.md | 2 +-
.../sql-functions/string-functions/left.md | 2 +-
.../sql-functions/string-functions/length.md | 2 +-
.../sql-functions/string-functions/like/like.md | 2 +-
.../string-functions/like/not_like.md | 2 +-
.../sql-functions/string-functions/locate.md | 2 +-
.../sql-functions/string-functions/lower.md | 2 +-
.../sql-functions/string-functions/lpad.md | 2 +-
.../sql-functions/string-functions/ltrim.md | 2 +-
.../sql-functions/string-functions/money_format.md | 2 +-
.../string-functions/null_or_empty.md | 2 +-
.../{find_in_set.md => parse_url.md} | 25 +++++++-------
.../string-functions/regexp/not_regexp.md | 2 +-
.../string-functions/regexp/regexp.md | 2 +-
.../string-functions/regexp/regexp_extract.md | 2 +-
.../string-functions/regexp/regexp_replace.md | 2 +-
.../sql-functions/string-functions/repeat.md | 2 +-
.../sql-functions/string-functions/replace.md | 2 +-
.../sql-functions/string-functions/reverse.md | 4 +--
.../sql-functions/string-functions/right.md | 2 +-
.../sql-functions/string-functions/rpad.md | 2 +-
.../string-functions/{ltrim.md => rtrim.md} | 22 ++++++------
.../sql-functions/string-functions/split_part.md | 2 +-
.../sql-functions/string-functions/starts_with.md | 2 +-
.../sql-functions/string-functions/strleft.md | 2 +-
.../sql-functions/string-functions/strright.md | 2 +-
.../sql-functions/string-functions/substring.md | 2 +-
.../string-functions/{ltrim.md => trim.md} | 20 +++++------
.../string-functions/{lcase.md => ucase.md} | 10 +++---
.../sql-functions/string-functions/unhex.md | 2 +-
.../string-functions/{lower.md => upper.md} | 16 ++++-----
sidebars.json | 39 ++++++++++++----------
83 files changed, 192 insertions(+), 196 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/string-functions/append_trailing_char_if_absent.md
b/docs/sql-manual/sql-functions/string-functions/append_trailing_char_if_absent.md
index 616f418d372..b97b503cb26 100644
---
a/docs/sql-manual/sql-functions/string-functions/append_trailing_char_if_absent.md
+++
b/docs/sql-manual/sql-functions/string-functions/append_trailing_char_if_absent.md
@@ -57,4 +57,4 @@ MySQL [test]> select append_trailing_char_if_absent('ac','c');
### keywords
-APPEND_TRAILING_CHAR_IF_ABSENT
+ APPEND_TRAILING_CHAR_IF_ABSENT
diff --git a/docs/sql-manual/sql-functions/string-functions/ascii.md
b/docs/sql-manual/sql-functions/string-functions/ascii.md
index 41e77177f5d..29e3dbc0957 100644
--- a/docs/sql-manual/sql-functions/string-functions/ascii.md
+++ b/docs/sql-manual/sql-functions/string-functions/ascii.md
@@ -51,4 +51,4 @@ mysql> select ascii('234');
+--------------+
```
### keywords
-ASCII
+ ASCII
diff --git a/docs/sql-manual/sql-functions/string-functions/bit_length.md
b/docs/sql-manual/sql-functions/string-functions/bit_length.md
index 287c6fc97f4..861a6b22599 100644
--- a/docs/sql-manual/sql-functions/string-functions/bit_length.md
+++ b/docs/sql-manual/sql-functions/string-functions/bit_length.md
@@ -51,4 +51,4 @@ mysql> select bit_length("中国");
+----------------------+
```
### keywords
-BIT_LENGTH
+ BIT_LENGTH
diff --git a/docs/sql-manual/sql-functions/string-functions/char_length.md
b/docs/sql-manual/sql-functions/string-functions/char_length.md
index 268d69ee58c..924466eeeb6 100644
--- a/docs/sql-manual/sql-functions/string-functions/char_length.md
+++ b/docs/sql-manual/sql-functions/string-functions/char_length.md
@@ -52,4 +52,4 @@ mysql> select char_length("中国");
+-----------------------+
```
### keywords
-CHAR_LENGTH, CHARACTER_LENGTH
+ CHAR_LENGTH, CHARACTER_LENGTH
diff --git a/docs/sql-manual/sql-functions/string-functions/concat.md
b/docs/sql-manual/sql-functions/string-functions/concat.md
index f5a662e314e..9799296136d 100644
--- a/docs/sql-manual/sql-functions/string-functions/concat.md
+++ b/docs/sql-manual/sql-functions/string-functions/concat.md
@@ -58,4 +58,4 @@ mysql> select concat("a", null, "c");
+------------------------+
```
### keywords
-CONCAT
+ CONCAT
diff --git a/docs/sql-manual/sql-functions/string-functions/concat_ws.md
b/docs/sql-manual/sql-functions/string-functions/concat_ws.md
index 80a0c11dee2..ccfa7afa41c 100644
--- a/docs/sql-manual/sql-functions/string-functions/concat_ws.md
+++ b/docs/sql-manual/sql-functions/string-functions/concat_ws.md
@@ -60,4 +60,4 @@ mysql> select concat_ws("or", "d", NULL,"is");
+---------------------------------+
```
### keywords
-CONCAT_WS,CONCAT,WS
+ CONCAT_WS,CONCAT,WS
diff --git a/docs/sql-manual/sql-functions/string-functions/ends_with.md
b/docs/sql-manual/sql-functions/string-functions/ends_with.md
index 38a297dc642..b5ed6c0ac93 100644
--- a/docs/sql-manual/sql-functions/string-functions/ends_with.md
+++ b/docs/sql-manual/sql-functions/string-functions/ends_with.md
@@ -51,4 +51,4 @@ mysql> select ends_with("Hello doris", "Hello");
+-----------------------------------+
```
### keywords
-ENDS_WITH
+ ENDS_WITH
diff --git a/docs/sql-manual/sql-functions/string-functions/find_in_set.md
b/docs/sql-manual/sql-functions/string-functions/find_in_set.md
index 08eabc2a651..c51e078fcba 100644
--- a/docs/sql-manual/sql-functions/string-functions/find_in_set.md
+++ b/docs/sql-manual/sql-functions/string-functions/find_in_set.md
@@ -46,4 +46,4 @@ mysql> select find_in_set("b", "a,b,c");
+---------------------------+
```
### keywords
-FIND_IN_SET,FIND,IN,SET
+ FIND_IN_SET,FIND,IN,SET
diff --git a/docs/sql-manual/sql-functions/string-functions/hex.md
b/docs/sql-manual/sql-functions/string-functions/hex.md
index 6a74fa3c4c8..6041a50641c 100644
--- a/docs/sql-manual/sql-functions/string-functions/hex.md
+++ b/docs/sql-manual/sql-functions/string-functions/hex.md
@@ -82,4 +82,4 @@ mysql> select hex(-1);
+------------------+
```
### keywords
-HEX
+ HEX
diff --git a/docs/sql-manual/sql-functions/string-functions/instr.md
b/docs/sql-manual/sql-functions/string-functions/instr.md
index 01132b84d7f..f9c160a3cec 100644
--- a/docs/sql-manual/sql-functions/string-functions/instr.md
+++ b/docs/sql-manual/sql-functions/string-functions/instr.md
@@ -51,4 +51,4 @@ mysql> select instr("abc", "d");
+-------------------+
```
### keywords
-INSTR
+ INSTR
diff --git a/docs/sql-manual/sql-functions/string-functions/lcase.md
b/docs/sql-manual/sql-functions/string-functions/lcase.md
index 48c295ee856..3f3ee92eff3 100644
--- a/docs/sql-manual/sql-functions/string-functions/lcase.md
+++ b/docs/sql-manual/sql-functions/string-functions/lcase.md
@@ -34,4 +34,4 @@ under the License.
Consistent with `lower`.
### keywords
-LCASE
+ LCASE
diff --git a/docs/sql-manual/sql-functions/string-functions/left.md
b/docs/sql-manual/sql-functions/string-functions/left.md
index 88122b874ef..bdf5789c9a5 100644
--- a/docs/sql-manual/sql-functions/string-functions/left.md
+++ b/docs/sql-manual/sql-functions/string-functions/left.md
@@ -44,4 +44,4 @@ mysql> select left("Hello doris",5);
+------------------------+
```
### keywords
-LEFT
+ LEFT
diff --git a/docs/sql-manual/sql-functions/string-functions/length.md
b/docs/sql-manual/sql-functions/string-functions/length.md
index 7870b8cf156..891fbcdeb1b 100644
--- a/docs/sql-manual/sql-functions/string-functions/length.md
+++ b/docs/sql-manual/sql-functions/string-functions/length.md
@@ -51,4 +51,4 @@ mysql> select length("中国");
+------------------+
```
### keywords
-LENGTH
+ LENGTH
diff --git a/docs/sql-manual/sql-functions/string-functions/like/like.md
b/docs/sql-manual/sql-functions/string-functions/like/like.md
index d357312c4ed..6524a164fae 100644
--- a/docs/sql-manual/sql-functions/string-functions/like/like.md
+++ b/docs/sql-manual/sql-functions/string-functions/like/like.md
@@ -80,4 +80,4 @@ mysql> select k1 from test where k1 like 'a';
```
### keywords
-LIKE
+ LIKE
diff --git a/docs/sql-manual/sql-functions/string-functions/like/not_like.md
b/docs/sql-manual/sql-functions/string-functions/like/not_like.md
index 2d3e8462304..1bc97cca205 100644
--- a/docs/sql-manual/sql-functions/string-functions/like/not_like.md
+++ b/docs/sql-manual/sql-functions/string-functions/like/not_like.md
@@ -82,4 +82,4 @@ mysql> select k1 from test where k1 not like 'a';
```
### keywords
-LIKE, NOT, NOT LIKE
+ LIKE, NOT, NOT LIKE
diff --git a/docs/sql-manual/sql-functions/string-functions/locate.md
b/docs/sql-manual/sql-functions/string-functions/locate.md
index aa99d7423a6..bab5940c767 100644
--- a/docs/sql-manual/sql-functions/string-functions/locate.md
+++ b/docs/sql-manual/sql-functions/string-functions/locate.md
@@ -58,4 +58,4 @@ mysql> SELECT LOCATE('bar', 'foobarbar', 5);
+-------------------------------+
```
### keywords
-LOCATE
+ LOCATE
diff --git a/docs/sql-manual/sql-functions/string-functions/lower.md
b/docs/sql-manual/sql-functions/string-functions/lower.md
index f85cf4a2c58..81ca6fb4517 100644
--- a/docs/sql-manual/sql-functions/string-functions/lower.md
+++ b/docs/sql-manual/sql-functions/string-functions/lower.md
@@ -44,4 +44,4 @@ mysql> SELECT lower("AbC123");
+-----------------+
```
### keywords
-LOWER
+ LOWER
diff --git a/docs/sql-manual/sql-functions/string-functions/lpad.md
b/docs/sql-manual/sql-functions/string-functions/lpad.md
index 50f3d679a63..2b478c3f1d3 100644
--- a/docs/sql-manual/sql-functions/string-functions/lpad.md
+++ b/docs/sql-manual/sql-functions/string-functions/lpad.md
@@ -51,4 +51,4 @@ mysql> SELECT lpad("hi", 1, "xy");
+---------------------+
```
### keywords
-LPAD
+ LPAD
diff --git a/docs/sql-manual/sql-functions/string-functions/ltrim.md
b/docs/sql-manual/sql-functions/string-functions/ltrim.md
index 1c1fb218f46..a29c9814b96 100644
--- a/docs/sql-manual/sql-functions/string-functions/ltrim.md
+++ b/docs/sql-manual/sql-functions/string-functions/ltrim.md
@@ -44,4 +44,4 @@ mysql> SELECT ltrim(' ab d');
+------------------+
```
### keywords
-LTRIM
+ LTRIM
diff --git a/docs/sql-manual/sql-functions/string-functions/money_format.md
b/docs/sql-manual/sql-functions/string-functions/money_format.md
index f4f6c473079..b5ae2f246d7 100644
--- a/docs/sql-manual/sql-functions/string-functions/money_format.md
+++ b/docs/sql-manual/sql-functions/string-functions/money_format.md
@@ -58,4 +58,4 @@ mysql> select money_format(1123.4);
+----------------------+
```
### keywords
-MONEY_FORMAT,MONEY,FORMAT
+ MONEY_FORMAT,MONEY,FORMAT
diff --git a/docs/sql-manual/sql-functions/string-functions/null_or_empty.md
b/docs/sql-manual/sql-functions/string-functions/null_or_empty.md
index 0c0d5d46d8a..1c6cf6a7387 100644
--- a/docs/sql-manual/sql-functions/string-functions/null_or_empty.md
+++ b/docs/sql-manual/sql-functions/string-functions/null_or_empty.md
@@ -57,4 +57,4 @@ MySQL [(none)]> select null_or_empty("a");
+--------------------+
```
### keywords
-NULL_OR_EMPTY
\ No newline at end of file
+ NULL_OR_EMPTY
\ No newline at end of file
diff --git a/docs/sql-manual/sql-functions/string-functions/reverse.md
b/docs/sql-manual/sql-functions/string-functions/parse_url.md
similarity index 58%
copy from docs/sql-manual/sql-functions/string-functions/reverse.md
copy to docs/sql-manual/sql-functions/string-functions/parse_url.md
index bd7c5889ee3..cf6e662af4e 100644
--- a/docs/sql-manual/sql-functions/string-functions/reverse.md
+++ b/docs/sql-manual/sql-functions/string-functions/parse_url.md
@@ -1,6 +1,6 @@
---
{
- "title": "reverse",
+ "title": "parse_url",
"language": "en"
}
---
@@ -24,33 +24,25 @@ specific language governing permissions and limitations
under the License.
-->
-## reverse
+## parse_url
### description
#### Syntax
-`VARCHAR reverse(VARCHAR str)`
+`VARCHAR parse_url(VARCHAR url, VARCHAR name)`
-The REVERSE() function reverses a string and returns the result.
+From the URL, the field corresponding to name is resolved. The name options
are as follows: 'PROTOCOL', 'HOST', 'PATH', 'REF', 'AUTHORITY', 'FILE',
'USERINFO', 'PORT', 'QUERY', and the result is returned.
### example
```
-mysql> SELECT REVERSE('hello');
-+------------------+
-| REVERSE('hello') |
-+------------------+
-| olleh |
-+------------------+
-1 row in set (0.00 sec)
-
-mysql> SELECT REVERSE('你好');
-+------------------+
-| REVERSE('你好') |
-+------------------+
-| 好你 |
-+------------------+
-1 row in set (0.00 sec)
+mysql> SELECT parse_url ('https://doris.apache.org/', 'HOST');
++------------------------------------------------+
+| parse_url('https://doris.apache.org/', 'HOST') |
++------------------------------------------------+
+| doris.apache.org |
++------------------------------------------------+
```
+
### keywords
-REVERSE
+ PARSE URL
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
index ca2e19f4b8b..c5d267568da 100644
--- a/docs/sql-manual/sql-functions/string-functions/regexp/not_regexp.md
+++ b/docs/sql-manual/sql-functions/string-functions/regexp/not_regexp.md
@@ -53,4 +53,4 @@ mysql> select k1 from test where k1 not regexp 'ok$';
```
### keywords
-REGEXP, NOT, NOT REGEXP
+ REGEXP, NOT, NOT REGEXP
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 41a1a239f8e..0f0b1d338c9 100644
--- a/docs/sql-manual/sql-functions/string-functions/regexp/regexp.md
+++ b/docs/sql-manual/sql-functions/string-functions/regexp/regexp.md
@@ -53,4 +53,4 @@ mysql> select k1 from test where k1 regexp 'ok$';
```
### keywords
-REGEXP
+ REGEXP
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 814605beca5..e2d59ee4460 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
@@ -51,4 +51,4 @@ mysql> SELECT regexp_extract('AbCdE',
'([[:lower:]]+)C([[:lower:]]+)', 2);
+-------------------------------------------------------------+
```
### keywords
-REGEXP_EXTRACT,REGEXP,EXTRACT
+ REGEXP_EXTRACT,REGEXP,EXTRACT
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 e9b611f6497..05ec3777b84 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
@@ -51,4 +51,4 @@ mysql> SELECT regexp_replace('a b c','(b)','<\\1>');
+----------------------------------------+
```
### keywords
-REGEXP_REPLACE,REGEXP,REPLACE
+ REGEXP_REPLACE,REGEXP,REPLACE
diff --git a/docs/sql-manual/sql-functions/string-functions/repeat.md
b/docs/sql-manual/sql-functions/string-functions/repeat.md
index ada0b7b3eb8..cfb826cc6a4 100644
--- a/docs/sql-manual/sql-functions/string-functions/repeat.md
+++ b/docs/sql-manual/sql-functions/string-functions/repeat.md
@@ -51,4 +51,4 @@ mysql> SELECT repeat("a", -1);
+-----------------+
```
### keywords
-REPEAT,
+ REPEAT
diff --git a/docs/sql-manual/sql-functions/string-functions/replace.md
b/docs/sql-manual/sql-functions/string-functions/replace.md
index b9946bf83b9..e036597b07a 100644
--- a/docs/sql-manual/sql-functions/string-functions/replace.md
+++ b/docs/sql-manual/sql-functions/string-functions/replace.md
@@ -43,4 +43,4 @@ mysql> select replace("http://www.baidu.com:9090";, "9090",
"");
+------------------------------------------------------+
```
### keywords
-REPLACE
+ REPLACE
diff --git a/docs/sql-manual/sql-functions/string-functions/reverse.md
b/docs/sql-manual/sql-functions/string-functions/reverse.md
index bd7c5889ee3..56a84de48d5 100644
--- a/docs/sql-manual/sql-functions/string-functions/reverse.md
+++ b/docs/sql-manual/sql-functions/string-functions/reverse.md
@@ -53,4 +53,4 @@ mysql> SELECT REVERSE('你好');
1 row in set (0.00 sec)
```
### keywords
-REVERSE
+ REVERSE
diff --git a/docs/sql-manual/sql-functions/string-functions/right.md
b/docs/sql-manual/sql-functions/string-functions/right.md
index 506949d6d86..cf5499a4c8d 100644
--- a/docs/sql-manual/sql-functions/string-functions/right.md
+++ b/docs/sql-manual/sql-functions/string-functions/right.md
@@ -44,4 +44,4 @@ mysql> select right("Hello doris",5);
+-------------------------+
```
### keywords
-RIGHT
+ RIGHT
diff --git a/docs/sql-manual/sql-functions/string-functions/rpad.md
b/docs/sql-manual/sql-functions/string-functions/rpad.md
index ffd97f5337c..310464c1d51 100644
--- a/docs/sql-manual/sql-functions/string-functions/rpad.md
+++ b/docs/sql-manual/sql-functions/string-functions/rpad.md
@@ -51,4 +51,4 @@ mysql> SELECT rpad("hi", 1, "xy");
+---------------------+
```
### keywords
-RPAD
+ RPAD
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ltrim.md
b/docs/sql-manual/sql-functions/string-functions/rtrim.md
similarity index 76%
copy from
i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ltrim.md
copy to docs/sql-manual/sql-functions/string-functions/rtrim.md
index 003756d829b..fb2752bef12 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ltrim.md
+++ b/docs/sql-manual/sql-functions/string-functions/rtrim.md
@@ -1,11 +1,11 @@
---
{
- "title": "ltrim",
- "language": "zh-CN"
+ "title": "rtrim",
+ "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
@@ -24,24 +24,24 @@ specific language governing permissions and limitations
under the License.
-->
-## ltrim
+## rtrim
### description
#### Syntax
`VARCHAR ltrim(VARCHAR str)`
-将参数 str 中从开始部分连续出现的空格去掉
+Remove the space that appears continuously from the ending of the parameter str
### example
```
-mysql> SELECT ltrim(' ab d');
-+------------------+
-| ltrim(' ab d') |
-+------------------+
-| ab d |
-+------------------+
+mysql> SELECT rtrim('ab d ') str;
++------+
+| str |
++------+
+| ab d |
++------+
```
### keywords
-LTRIM
+ RTRIM
diff --git a/docs/sql-manual/sql-functions/string-functions/split_part.md
b/docs/sql-manual/sql-functions/string-functions/split_part.md
index 3261ca9082c..67a7bc721aa 100644
--- a/docs/sql-manual/sql-functions/string-functions/split_part.md
+++ b/docs/sql-manual/sql-functions/string-functions/split_part.md
@@ -66,4 +66,4 @@ mysql> select split_part("abca", "a", 1);
+----------------------------+
```
### keywords
-SPLIT_PART,SPLIT,PART
+ SPLIT_PART,SPLIT,PART
diff --git a/docs/sql-manual/sql-functions/string-functions/starts_with.md
b/docs/sql-manual/sql-functions/string-functions/starts_with.md
index 10fbf1c40bd..2bcb0b627cf 100644
--- a/docs/sql-manual/sql-functions/string-functions/starts_with.md
+++ b/docs/sql-manual/sql-functions/string-functions/starts_with.md
@@ -51,4 +51,4 @@ MySQL [(none)]> select starts_with("hello world","world");
+-------------------------------------+
```
### keywords
-STARTS_WITH
\ No newline at end of file
+ STARTS_WITH
\ No newline at end of file
diff --git a/docs/sql-manual/sql-functions/string-functions/strleft.md
b/docs/sql-manual/sql-functions/string-functions/strleft.md
index 4049b4d892f..843560bfac8 100644
--- a/docs/sql-manual/sql-functions/string-functions/strleft.md
+++ b/docs/sql-manual/sql-functions/string-functions/strleft.md
@@ -44,4 +44,4 @@ mysql> select strleft("Hello doris",5);
+------------------------+
```
### keywords
-STRLEFT
+ STRLEFT
diff --git a/docs/sql-manual/sql-functions/string-functions/strright.md
b/docs/sql-manual/sql-functions/string-functions/strright.md
index 49d08851f3b..68fee0190b1 100644
--- a/docs/sql-manual/sql-functions/string-functions/strright.md
+++ b/docs/sql-manual/sql-functions/string-functions/strright.md
@@ -45,4 +45,4 @@ mysql> select strright("Hello doris",5);
+-------------------------+
```
### keywords
-STRRIGHT
+ STRRIGHT
diff --git a/docs/sql-manual/sql-functions/string-functions/substring.md
b/docs/sql-manual/sql-functions/string-functions/substring.md
index 49cf21f0818..afd490e37a3 100644
--- a/docs/sql-manual/sql-functions/string-functions/substring.md
+++ b/docs/sql-manual/sql-functions/string-functions/substring.md
@@ -74,4 +74,4 @@ mysql> select substring('abc1def', 2, 2);
```
### keywords
-SUBSTRING
+ SUBSTRING
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ltrim.md
b/docs/sql-manual/sql-functions/string-functions/trim.md
similarity index 77%
copy from
i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ltrim.md
copy to docs/sql-manual/sql-functions/string-functions/trim.md
index 003756d829b..c6b8034fe4a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ltrim.md
+++ b/docs/sql-manual/sql-functions/string-functions/trim.md
@@ -1,7 +1,7 @@
---
{
- "title": "ltrim",
- "language": "zh-CN"
+ "title": "trim",
+ "language": "en"
}
---
@@ -24,24 +24,24 @@ specific language governing permissions and limitations
under the License.
-->
-## ltrim
+## trim
### description
#### Syntax
`VARCHAR ltrim(VARCHAR str)`
-将参数 str 中从开始部分连续出现的空格去掉
+Remove the space that appears continuously from the starring and ending of the
parameter str
### example
```
-mysql> SELECT ltrim(' ab d');
-+------------------+
-| ltrim(' ab d') |
-+------------------+
-| ab d |
-+------------------+
+mysql> SELECT trim(' ab d ') str;
++------+
+| str |
++------+
+| ab d |
++------+
```
### keywords
-LTRIM
+ TRIM
diff --git a/docs/sql-manual/sql-functions/string-functions/lcase.md
b/docs/sql-manual/sql-functions/string-functions/ucase.md
similarity index 88%
copy from docs/sql-manual/sql-functions/string-functions/lcase.md
copy to docs/sql-manual/sql-functions/string-functions/ucase.md
index 48c295ee856..cf2879d0953 100644
--- a/docs/sql-manual/sql-functions/string-functions/lcase.md
+++ b/docs/sql-manual/sql-functions/string-functions/ucase.md
@@ -1,6 +1,6 @@
---
{
- "title": "lcase",
+ "title": "ucase",
"language": "en"
}
---
@@ -24,14 +24,14 @@ specific language governing permissions and limitations
under the License.
-->
-## lcase
-### Description
+## ucase
+### description
#### Syntax
-`INT lcase (VARCHAR str)`
+`INT ucase(VARCHAR str)`
-Consistent with `lower`.
+Consistent with `upper`.
### keywords
-LCASE
+ UCASE
diff --git a/docs/sql-manual/sql-functions/string-functions/unhex.md
b/docs/sql-manual/sql-functions/string-functions/unhex.md
index 42bd20f7623..fb66dc43e1f 100644
--- a/docs/sql-manual/sql-functions/string-functions/unhex.md
+++ b/docs/sql-manual/sql-functions/string-functions/unhex.md
@@ -60,4 +60,4 @@ mysql> select unhex('4142');
+---------------+
```
### keywords
-UNHEX
+ UNHEX
diff --git a/docs/sql-manual/sql-functions/string-functions/lower.md
b/docs/sql-manual/sql-functions/string-functions/upper.md
similarity index 81%
copy from docs/sql-manual/sql-functions/string-functions/lower.md
copy to docs/sql-manual/sql-functions/string-functions/upper.md
index f85cf4a2c58..14a4ed5e1d1 100644
--- a/docs/sql-manual/sql-functions/string-functions/lower.md
+++ b/docs/sql-manual/sql-functions/string-functions/upper.md
@@ -1,6 +1,6 @@
---
{
- "title": "lower",
+ "title": "upper",
"language": "en"
}
---
@@ -24,24 +24,24 @@ specific language governing permissions and limitations
under the License.
-->
-## lower
-### Description
+## upper
+### description
#### Syntax
-`INT lower (VARCHAR str)`
+`INT upper(VARCHAR str)`
-Convert all strings in parameters to lowercase
+Convert all strings in parameters to uppercase
### example
```
-mysql> SELECT lower("AbC123");
+mysql> SELECT upper("aBc123");
+-----------------+
-| lower('AbC123') |
+| upper('aBc123') |
+-----------------+
-| abc123 |
+| ABC123 |
+-----------------+
```
### keywords
-LOWER
+ UPPER
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/append_trailing_char_if_absent.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/append_trailing_char_if_absent.md
index 43ca0c12c0b..dd031e07317 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/append_trailing_char_if_absent.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/append_trailing_char_if_absent.md
@@ -57,4 +57,4 @@ MySQL [test]> select append_trailing_char_if_absent('ac','c');
### keywords
-APPEND_TRAILING_CHAR_IF_ABSENT
+ APPEND_TRAILING_CHAR_IF_ABSENT
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ascii.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ascii.md
index cef492b75cb..31b08c8fcbb 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ascii.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ascii.md
@@ -51,4 +51,4 @@ mysql> select ascii('234');
+--------------+
```
### keywords
-ASCII
+ ASCII
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/bit_length.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/bit_length.md
index ce294cfcbf5..d50ef0b201b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/bit_length.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/bit_length.md
@@ -51,4 +51,4 @@ mysql> select bit_length("中国");
+----------------------+
```
### keywords
-BIT_LENGTH
+ BIT_LENGTH
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/char_length.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/char_length.md
index f0ee2ff17e5..cf8b64f123a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/char_length.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/char_length.md
@@ -1,6 +1,6 @@
---
{
- "title": "CHAR_LENGTH",
+ "title": "char_length",
"language": "zh-CN"
}
---
@@ -51,4 +51,4 @@ mysql> select char_length("中国");
+-----------------------+
```
### keywords
-CHAR_LENGTH, CHARACTER_LENGTH
+ CHAR_LENGTH, CHARACTER_LENGTH
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/concat.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/concat.md
index 01bd503fd53..c68e2563436 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/concat.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/concat.md
@@ -58,4 +58,4 @@ mysql> select concat("a", null, "c");
+------------------------+
```
### keywords
-CONCAT
+ CONCAT
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/concat_ws.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/concat_ws.md
index bcebf9f4a60..f8777fbb4f3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/concat_ws.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/concat_ws.md
@@ -60,4 +60,4 @@ mysql> select concat_ws("or", "d", NULL,"is");
+---------------------------------+
```
### keywords
-CONCAT_WS,CONCAT,WS
+ CONCAT_WS,CONCAT,WS
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ends_with.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ends_with.md
index a6546313848..f289803d812 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ends_with.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ends_with.md
@@ -50,4 +50,4 @@ mysql> select ends_with("Hello doris", "Hello");
+-----------------------------------+
```
### keywords
-ENDS_WITH
+ ENDS_WITH
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/find_in_set.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/find_in_set.md
index 25fa21d4d3d..38e3dd456fc 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/find_in_set.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/find_in_set.md
@@ -44,4 +44,4 @@ mysql> select find_in_set("b", "a,b,c");
+---------------------------+
```
### keywords
-FIND_IN_SET,FIND,IN,SET
+ FIND_IN_SET,FIND,IN,SET
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/hex.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/hex.md
index 6d2893789e8..b15ceaa2f8b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/hex.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/hex.md
@@ -82,4 +82,4 @@ mysql> select hex(-1);
+------------------+
```
### keywords
-HEX
+ HEX
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/instr.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/instr.md
index 2aa8936858a..b3b7e0155fb 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/instr.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/instr.md
@@ -51,4 +51,4 @@ mysql> select instr("abc", "d");
+-------------------+
```
### keywords
-INSTR
+ INSTR
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/lcase.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/lcase.md
index 7edd3cc1c5f..61a95984039 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/lcase.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/lcase.md
@@ -34,4 +34,4 @@ under the License.
与`lower`一致
### keywords
-LCASE
+ LCASE
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/left.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/left.md
index 1cf51319233..357f0e1cd2c 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/left.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/left.md
@@ -44,4 +44,4 @@ mysql> select left("Hello doris",5);
+------------------------+
```
### keywords
-LEFT
+ LEFT
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/length.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/length.md
index b83373811d5..f9c9499c423 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/length.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/length.md
@@ -51,4 +51,4 @@ mysql> select length("中国");
+------------------+
```
### keywords
-LENGTH
+ LENGTH
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/like/like.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/like/like.md
index 223fd220739..06bdaf2dabd 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/like/like.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/like/like.md
@@ -80,4 +80,4 @@ mysql > select k1 from test where k1 like 'a';
```
### keywords
-LIKE
+ LIKE
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/like/not_like.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/like/not_like.md
index 7d6fba9ab00..c7efbb8f416 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/like/not_like.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/like/not_like.md
@@ -82,4 +82,4 @@ mysql > select k1 from test where k1 not like 'a';
```
### keywords
-LIKE, NOT, NOT LIKE
+ LIKE, NOT, NOT LIKE
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/locate.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/locate.md
index aa0adf2146b..c7a85e20cd2 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/locate.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/locate.md
@@ -58,4 +58,4 @@ mysql> SELECT LOCATE('bar', 'foobarbar', 5);
+-------------------------------+
```
### keywords
-LOCATE
+ LOCATE
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/lower.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/lower.md
index 5d6d0da4f65..177b22572a0 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/lower.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/lower.md
@@ -44,4 +44,4 @@ mysql> SELECT lower("AbC123");
+-----------------+
```
### keywords
-LOWER
+ LOWER
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/lpad.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/lpad.md
index d94f44082e6..5eb72465fef 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/lpad.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/lpad.md
@@ -51,4 +51,4 @@ mysql> SELECT lpad("hi", 1, "xy");
+---------------------+
```
### keywords
-LPAD
+ LPAD
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ltrim.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ltrim.md
index 003756d829b..50f4c8e7fbd 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ltrim.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ltrim.md
@@ -44,4 +44,4 @@ mysql> SELECT ltrim(' ab d');
+------------------+
```
### keywords
-LTRIM
+ LTRIM
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/money_format.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/money_format.md
index d4faebd9344..0470807f0bc 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/money_format.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/money_format.md
@@ -58,4 +58,4 @@ mysql> select money_format(1123.4);
+----------------------+
```
### keywords
-MONEY_FORMAT,MONEY,FORMAT
+ MONEY_FORMAT,MONEY,FORMAT
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/null_or_empty.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/null_or_empty.md
index 9f8ccd3ce53..e05e10d50ff 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/null_or_empty.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/null_or_empty.md
@@ -57,4 +57,4 @@ MySQL [(none)]> select null_or_empty("a");
+--------------------+
```
### keywords
-NULL_OR_EMPTY
+ NULL_OR_EMPTY
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/find_in_set.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/parse_url.md
similarity index 59%
copy from
i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/find_in_set.md
copy to
i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/parse_url.md
index 25fa21d4d3d..dd25203b143 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/find_in_set.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/parse_url.md
@@ -1,6 +1,6 @@
---
{
- "title": "find_in_set",
+ "title": "parse_url",
"language": "zh-CN"
}
---
@@ -24,24 +24,23 @@ specific language governing permissions and limitations
under the License.
-->
-## find_in_set
+## parse_url
### description
#### Syntax
-`INT find_in_set(VARCHAR str, VARCHAR strlist)`
+`VARCHAR parse_url(VARCHAR url, VARCHAR name)`
-返回 strlist 中第一次出现 str 的位置（从1开始计数）。strlist 是用逗号分隔的字符串。如果没有找到，返回0。任意参数为 NULL ，返回
NULL。
-
-### example
+在url解析出name对应的字段，name可选项为：'PROTOCOL', 'HOST', 'PATH', 'REF', 'AUTHORITY',
'FILE', 'USERINFO', 'PORT', 'QUERY'，将结果返回。
```
-mysql> select find_in_set("b", "a,b,c");
-+---------------------------+
-| find_in_set('b', 'a,b,c') |
-+---------------------------+
-| 2 |
-+---------------------------+
+mysql> SELECT parse_url ('https://doris.apache.org/', 'HOST');
++------------------------------------------------+
+| parse_url('https://doris.apache.org/', 'HOST') |
++------------------------------------------------+
+| doris.apache.org |
++------------------------------------------------+
```
+
### keywords
-FIND_IN_SET,FIND,IN,SET
+ PARSE URL
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
index 5f07c927772..7e7bb278c5d 100644
---
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
@@ -53,4 +53,4 @@ mysql > select k1 from test where k1 not regexp 'ok$';
```
### keywords
-REGEXP, NOT, NOT REGEXP
+ REGEXP, NOT, NOT REGEXP
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 b42d7278d3a..f4e690c08ce 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
@@ -53,4 +53,4 @@ mysql > select k1 from test where k1 regexp 'ok$';
```
### keywords
-REGEXP
+ REGEXP
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 f1fbaaf8822..275113672c6 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
@@ -48,4 +48,4 @@ mysql> SELECT regexp_extract('AbCdE',
'([[:lower:]]+)C([[:lower:]]+)', 2);
+-------------------------------------------------------------+
```
### keywords
-REGEXP_EXTRACT,REGEXP,EXTRACT
+ REGEXP_EXTRACT,REGEXP,EXTRACT
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 76e748cc4fd..df3e654478f 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
@@ -51,4 +51,4 @@ mysql> SELECT regexp_replace('a b c','(b)','<\\1>');
+----------------------------------------+
```
### keywords
-REGEXP_REPLACE,REGEXP,REPLACE
+ REGEXP_REPLACE,REGEXP,REPLACE
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/repeat.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/repeat.md
index b4b8a579ec7..def735035b5 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/repeat.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/repeat.md
@@ -51,4 +51,4 @@ mysql> SELECT repeat("a", -1);
+-----------------+
```
### keywords
-REPEAT,
+ REPEAT
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/replace.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/replace.md
index 9b317291b56..4b88f118680 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/replace.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/replace.md
@@ -43,4 +43,4 @@ mysql> select replace("http://www.baidu.com:9090";, "9090",
"");
+------------------------------------------------------+
```
### keywords
-REPLACE
+ REPLACE
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/reverse.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/reverse.md
index 19477b05b43..c25bae8f8f4 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/reverse.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/reverse.md
@@ -1,6 +1,6 @@
---
{
- "title": "REVERSE",
+ "title": "reverse",
"language": "zh-CN"
}
---
@@ -53,4 +53,4 @@ mysql> SELECT REVERSE('你好');
1 row in set (0.00 sec)
```
### keywords
-REVERSE
+ REVERSE
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/right.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/right.md
index ec8d1bf42d1..f820a08ad68 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/right.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/right.md
@@ -44,4 +44,4 @@ mysql> select right("Hello doris",5);
+-------------------------+
```
### keywords
-RIGHT
+ RIGHT
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/rpad.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/rpad.md
index f7361efd732..2bd4ce329f8 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/rpad.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/rpad.md
@@ -51,4 +51,4 @@ mysql> SELECT rpad("hi", 1, "xy");
+---------------------+
```
### keywords
-RPAD
+ RPAD
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ltrim.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/rtrim.md
similarity index 78%
copy from
i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ltrim.md
copy to
i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/rtrim.md
index 003756d829b..9774fe60355 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ltrim.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/rtrim.md
@@ -1,11 +1,11 @@
---
{
- "title": "ltrim",
+ "title": "rtrim",
"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
@@ -24,24 +24,24 @@ specific language governing permissions and limitations
under the License.
-->
-## ltrim
+## rtrim
### description
#### Syntax
`VARCHAR ltrim(VARCHAR str)`
-将参数 str 中从开始部分连续出现的空格去掉
+将参数 str 中从右侧部分开始部分连续出现的空格去掉
### example
```
-mysql> SELECT ltrim(' ab d');
-+------------------+
-| ltrim(' ab d') |
-+------------------+
-| ab d |
-+------------------+
+mysql> SELECT rtrim('ab d ') str;
++------+
+| str |
++------+
+| ab d |
++------+
```
### keywords
-LTRIM
+ RTRIM
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/split_part.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/split_part.md
index 204a202c32f..00e5620f53e 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/split_part.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/split_part.md
@@ -66,4 +66,4 @@ mysql> select split_part("abca", "a", 1);
+----------------------------+
```
### keywords
-SPLIT_PART,SPLIT,PART
+ SPLIT_PART,SPLIT,PART
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/starts_with.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/starts_with.md
index e6a7308b117..9219eb9a380 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/starts_with.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/starts_with.md
@@ -50,4 +50,4 @@ MySQL [(none)]> select starts_with("hello world","world");
+-------------------------------------+
```
### keywords
-STARTS_WITH
+ STARTS_WITH
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/strleft.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/strleft.md
index 47f3cd967cd..78473b57208 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/strleft.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/strleft.md
@@ -44,4 +44,4 @@ mysql> select strleft("Hello doris",5);
+------------------------+
```
### keywords
-STRLEFT
+ STRLEFT
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/strright.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/strright.md
index 10b090f864e..21ad8120f13 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/strright.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/strright.md
@@ -44,4 +44,4 @@ mysql> select strright("Hello doris",5);
+-------------------------+
```
### keywords
-STRRIGHT
+ STRRIGHT
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/substring.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/substring.md
index 736551de554..7494c384c4e 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/substring.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/substring.md
@@ -69,4 +69,4 @@ mysql> select substring('abc1def', 2, 2);
+-----------------------------+
```
### keywords
-SUBSTRING
+ SUBSTRING
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ltrim.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/trim.md
similarity index 79%
copy from
i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ltrim.md
copy to
i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/trim.md
index 003756d829b..c6c5e1b67b2 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ltrim.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/trim.md
@@ -1,6 +1,6 @@
---
{
- "title": "ltrim",
+ "title": "trim",
"language": "zh-CN"
}
---
@@ -24,24 +24,24 @@ specific language governing permissions and limitations
under the License.
-->
-## ltrim
+## trim
### description
#### Syntax
`VARCHAR ltrim(VARCHAR str)`
-将参数 str 中从开始部分连续出现的空格去掉
+将参数 str 中右侧和左侧开始部分连续出现的空格去掉
### example
```
-mysql> SELECT ltrim(' ab d');
-+------------------+
-| ltrim(' ab d') |
-+------------------+
-| ab d |
-+------------------+
+mysql> SELECT trim(' ab d ') str;
++------+
+| str |
++------+
+| ab d |
++------+
```
### keywords
-LTRIM
+ TRIM
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/lcase.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ucase.md
similarity index 91%
copy from
i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/lcase.md
copy to
i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ucase.md
index 7edd3cc1c5f..7b663bd46a5 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/lcase.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/ucase.md
@@ -1,6 +1,6 @@
---
{
- "title": "lcase",
+ "title": "ucase",
"language": "zh-CN"
}
---
@@ -24,14 +24,14 @@ specific language governing permissions and limitations
under the License.
-->
-## lcase
+## ucase
### description
#### Syntax
-`INT lcase(VARCHAR str)`
+`INT ucase(VARCHAR str)`
-与`lower`一致
+与`upper`一致
### keywords
-LCASE
+ UCASE
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/unhex.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/unhex.md
index 28b50e966c1..8f4aa12329e 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/unhex.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/unhex.md
@@ -60,4 +60,4 @@ mysql> select unhex('4142');
+---------------+
```
### keywords
-UNHEX
+ UNHEX
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/lower.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/upper.md
similarity index 83%
copy from
i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/lower.md
copy to
i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/upper.md
index 5d6d0da4f65..953b646ad08 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/lower.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/upper.md
@@ -1,6 +1,6 @@
---
{
- "title": "lower",
+ "title": "upper",
"language": "zh-CN"
}
---
@@ -24,24 +24,24 @@ specific language governing permissions and limitations
under the License.
-->
-## lower
+## upper
### description
#### Syntax
-`INT lower(VARCHAR str)`
+`INT upper(VARCHAR str)`
-将参数中所有的字符串都转换成小写
+将参数中所有的字符串都转换成大写
### example
```
-mysql> SELECT lower("AbC123");
+mysql> SELECT upper("aBc123");
+-----------------+
-| lower('AbC123') |
+| upper('aBc123') |
+-----------------+
-| abc123 |
+| ABC123 |
+-----------------+
```
### keywords
-LOWER
+ UPPER
diff --git a/sidebars.json b/sidebars.json
index 9401edfce6b..87874d7281b 100644
--- a/sidebars.json
+++ b/sidebars.json
@@ -313,36 +313,41 @@
"type": "category",
"label": "String Functions",
"items": [
-
"sql-manual/sql-functions/string-functions/append_trailing_char_if_absent",
"sql-manual/sql-functions/string-functions/ascii",
+
"sql-manual/sql-functions/string-functions/length",
"sql-manual/sql-functions/string-functions/bit_length",
"sql-manual/sql-functions/string-functions/char_length",
+
"sql-manual/sql-functions/string-functions/lpad",
+
"sql-manual/sql-functions/string-functions/rpad",
+
"sql-manual/sql-functions/string-functions/lower",
+
"sql-manual/sql-functions/string-functions/lcase",
+
"sql-manual/sql-functions/string-functions/upper",
+
"sql-manual/sql-functions/string-functions/ucase",
+
"sql-manual/sql-functions/string-functions/repeat",
+
"sql-manual/sql-functions/string-functions/reverse",
"sql-manual/sql-functions/string-functions/concat",
"sql-manual/sql-functions/string-functions/concat_ws",
+
"sql-manual/sql-functions/string-functions/substring",
+
"sql-manual/sql-functions/string-functions/append_trailing_char_if_absent",
"sql-manual/sql-functions/string-functions/ends_with",
-
"sql-manual/sql-functions/string-functions/find_in_set",
+
"sql-manual/sql-functions/string-functions/starts_with",
+
"sql-manual/sql-functions/string-functions/trim",
+
"sql-manual/sql-functions/string-functions/ltrim",
+
"sql-manual/sql-functions/string-functions/rtrim",
+
"sql-manual/sql-functions/string-functions/null_or_empty",
"sql-manual/sql-functions/string-functions/hex",
+
"sql-manual/sql-functions/string-functions/unhex",
"sql-manual/sql-functions/string-functions/instr",
-
"sql-manual/sql-functions/string-functions/lcase",
-
"sql-manual/sql-functions/string-functions/left",
-
"sql-manual/sql-functions/string-functions/length",
"sql-manual/sql-functions/string-functions/locate",
-
"sql-manual/sql-functions/string-functions/lower",
-
"sql-manual/sql-functions/string-functions/lpad",
-
"sql-manual/sql-functions/string-functions/ltrim",
-
"sql-manual/sql-functions/string-functions/money_format",
-
"sql-manual/sql-functions/string-functions/null_or_empty",
-
"sql-manual/sql-functions/string-functions/repeat",
+
"sql-manual/sql-functions/string-functions/find_in_set",
"sql-manual/sql-functions/string-functions/replace",
-
"sql-manual/sql-functions/string-functions/reverse",
+
"sql-manual/sql-functions/string-functions/left",
"sql-manual/sql-functions/string-functions/right",
-
"sql-manual/sql-functions/string-functions/rpad",
-
"sql-manual/sql-functions/string-functions/split_part",
-
"sql-manual/sql-functions/string-functions/starts_with",
"sql-manual/sql-functions/string-functions/strleft",
"sql-manual/sql-functions/string-functions/strright",
-
"sql-manual/sql-functions/string-functions/substring",
-
"sql-manual/sql-functions/string-functions/unhex",
+
"sql-manual/sql-functions/string-functions/split_part",
+
"sql-manual/sql-functions/string-functions/money_format",
+
"sql-manual/sql-functions/string-functions/parse_url",
{
"type": "category",
"label": "Fuzzy Match",
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
