This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 978dae267e [typo](docs)Optimized string and date function doc (#12949)
978dae267e is described below
commit 978dae267e01df730bca651b981d359db33263f7
Author: zy-kkk <zhong...@qq.com>
AuthorDate: Mon Sep 26 09:26:12 2022 +0800
[typo](docs)Optimized string and date function doc (#12949)
---
.../date-time-functions/current_timestamp.md | 2 +-
.../sql-functions/date-time-functions/date_add.md | 2 +-
.../date-time-functions/date_format.md | 2 +-
.../sql-functions/date-time-functions/date_sub.md | 2 +-
.../sql-functions/date-time-functions/datediff.md | 2 +-
.../sql-functions/date-time-functions/day.md | 2 +-
.../sql-functions/date-time-functions/dayname.md | 2 +-
.../date-time-functions/dayofmonth.md | 2 +-
.../sql-functions/date-time-functions/dayofweek.md | 2 +-
.../sql-functions/date-time-functions/dayofyear.md | 2 +-
.../sql-functions/date-time-functions/from_days.md | 4 +-
.../date-time-functions/from_unixtime.md | 1 +
.../sql-functions/date-time-functions/hour.md | 2 +-
.../sql-functions/date-time-functions/makedate.md | 2 +-
.../sql-functions/date-time-functions/minute.md | 2 +-
.../sql-functions/date-time-functions/month.md | 2 +-
.../sql-functions/date-time-functions/monthname.md | 2 +-
.../sql-functions/date-time-functions/now.md | 2 +-
.../sql-functions/date-time-functions/second.md | 2 +-
.../date-time-functions/time_round.md | 2 +-
.../sql-functions/date-time-functions/timediff.md | 2 +-
.../date-time-functions/timestampadd.md | 2 +-
.../date-time-functions/timestampdiff.md | 2 +-
.../sql-functions/date-time-functions/to_days.md | 2 +-
.../date-time-functions/utc_timestamp.md | 3 +-
.../sql-functions/date-time-functions/week.md | 2 +-
.../sql-functions/date-time-functions/weekday.md | 2 +-
.../date-time-functions/weekofyear.md | 2 +-
.../sql-functions/date-time-functions/year.md | 2 +-
.../sql-functions/date-time-functions/yearweek.md | 3 +-
.../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/elt.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 | 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/substr.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 ++++----
docs/sidebars.json | 52 ++++++++++++----------
.../sql-functions/date-time-functions/day.md | 2 +-
.../sql-functions/date-time-functions/hour.md | 2 +-
.../sql-functions/date-time-functions/makedate.md | 3 +-
.../sql-functions/date-time-functions/minute.md | 2 +-
.../sql-functions/date-time-functions/second.md | 2 +-
.../date-time-functions/time_round.md | 2 +-
.../date-time-functions/timestampadd.md | 2 +-
.../date-time-functions/timestampdiff.md | 2 +-
.../sql-functions/date-time-functions/weekday.md | 2 +-
.../sql-functions/date-time-functions/yearweek.md | 1 +
.../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/elt.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 | 16 +++----
.../sql-functions/string-functions/money_format.md | 2 +-
.../string-functions/null_or_empty.md | 2 +-
.../second.md => string-functions/parse_url.md} | 27 +++++------
.../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/substr.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 +++----
127 files changed, 255 insertions(+), 246 deletions(-)
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/current_timestamp.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/current_timestamp.md
index 4aa391d36e..0db0cb1fa5 100644
---
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/current_timestamp.md
+++
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/current_timestamp.md
@@ -66,4 +66,4 @@ Note:
2. Limited by the JDK implementation, if you use jdk8 to build FE, the
precision can be up to milliseconds (three decimal places), and the larger
precision bits will be filled with 0. If you need higher accuracy, please use
jdk11 to build FE.
### keywords
-CURRENT_TIMESTAMP,CURRENT,TIMESTAMP
+ CURRENT_TIMESTAMP,CURRENT,TIMESTAMP
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/date_add.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/date_add.md
index b1868755dc..61168bc425 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/date_add.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/date_add.md
@@ -50,4 +50,4 @@ mysql> select date_add('2010-11-30 23:59:59', INTERVAL 2 DAY);
+-------------------------------------------------+
```
### keywords
-DATE_ADD,DATE,ADD
+ DATE_ADD,DATE,ADD
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/date_format.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/date_format.md
index 5ecfe0b983..f699490f1d 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/date_format.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/date_format.md
@@ -163,4 +163,4 @@ mysql> select date_format('2006-06-01', '%%%d');
+--------------------------------------------+
```
### keywords
-DATE_FORMAT,DATE,FORMAT
+ DATE_FORMAT,DATE,FORMAT
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/date_sub.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/date_sub.md
index 0a83c034fb..8f1b4459c8 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/date_sub.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/date_sub.md
@@ -50,4 +50,4 @@ mysql> select date_sub('2010-11-30 23:59:59', INTERVAL 2 DAY);
+-------------------------------------------------+
```
### keywords
-Date, date, date
+ Date, date, date
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/datediff.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/datediff.md
index 9f84b138d5..781342fa85 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/datediff.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/datediff.md
@@ -56,4 +56,4 @@ mysql> select datediff(CAST('2010-11-30 23:59:59' AS
DATETIME), CAST('2010-12-31
+-----------------------------------------------------------------------------------+
```
### keywords
-DATEDIFF
+ DATEDIFF
diff --git a/docs/en/docs/sql-manual/sql-functions/date-time-functions/day.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/day.md
index 999185f9e8..c0368f739d 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/day.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/day.md
@@ -46,4 +46,4 @@ mysql> select day('1987-01-31');
+----------------------------+
```
### keywords
-DAY
+ DAY
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/dayname.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/dayname.md
index 369504f174..4896c6f4de 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/dayname.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/dayname.md
@@ -46,4 +46,4 @@ mysql> select dayname('2007-02-03 00:00:00');
+--------------------------------+
```
### keywords
-DAYNAME
+ DAYNAME
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/dayofmonth.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/dayofmonth.md
index 3d356b5e9f..95ea8dd3da 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/dayofmonth.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/dayofmonth.md
@@ -47,4 +47,4 @@ mysql> select dayofmonth('1987-01-31');
+-----------------------------------+
```
### keywords
-DAYOFMONTH
+ DAYOFMONTH
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/dayofweek.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/dayofweek.md
index ad2004f5a6..2fa5d1d2b1 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/dayofweek.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/dayofweek.md
@@ -52,4 +52,4 @@ mysql> select dayofweek(cast(20190625 as date));
+-----------------------------------+
```
### keywords
-DAYOFWEEK
+ DAYOFWEEK
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/dayofyear.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/dayofyear.md
index fe89753205..e498b8c40e 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/dayofyear.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/dayofyear.md
@@ -47,4 +47,4 @@ mysql> select dayofyear('2007-02-03 00:00:00');
+----------------------------------+
```
### keywords
-DAYOFYEAR
+ DAYOFYEAR
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/from_days.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/from_days.md
index 69f043009d..d774a27d73 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/from_days.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/from_days.md
@@ -42,5 +42,7 @@ mysql > select from u days (730669);
+-------------------+
| 2000-07-03 |
+-------------------+
+```
+
### keywords
-FROM_DAYS,FROM,DAYS
+ FROM_DAYS,FROM,DAYS
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/from_unixtime.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/from_unixtime.md
index 832720d83e..f34357d184 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/from_unixtime.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/from_unixtime.md
@@ -61,6 +61,7 @@ mysql> select from_unixtime(1196440219, '%Y-%m-%d %H:%i:%s');
+--------------------------------------------------+
| 2007-12-01 00:30:19 |
+--------------------------------------------------+
+```
### keywords
diff --git a/docs/en/docs/sql-manual/sql-functions/date-time-functions/hour.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/hour.md
index 8926c9da6f..fa1c50c9d9 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/hour.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/hour.md
@@ -45,4 +45,4 @@ mysql> select hour('2018-12-31 23:59:59');
+-----------------------------+
```
### keywords
-HOUR
+ HOUR
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/makedate.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/makedate.md
index 59a99ccbba..adc3fda8c9 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/makedate.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/makedate.md
@@ -42,4 +42,4 @@ mysql> select makedate(2021,1), makedate(2021,100),
makedate(2021,400);
+-------------------+---------------------+---------------------+
```
### keywords
- MAKEDATE
\ No newline at end of file
+ MAKEDATE
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/minute.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/minute.md
index dfc7a09a0a..1805b3f36c 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/minute.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/minute.md
@@ -45,4 +45,4 @@ mysql> select minute('2018-12-31 23:59:59');
+-----------------------------+
```
### keywords
-MINUTE
+ MINUTE
diff --git a/docs/en/docs/sql-manual/sql-functions/date-time-functions/month.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/month.md
index b5466c5322..2c7cda1824 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/month.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/month.md
@@ -46,4 +46,4 @@ mysql> select month('1987-01-01');
+-----------------------------+
```
### keywords
-MONTH
+ MONTH
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/monthname.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/monthname.md
index 013129c14b..78dbd26afa 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/monthname.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/monthname.md
@@ -46,4 +46,4 @@ mysql> select monthname('2008-02-03 00:00:00');
+----------------------------------+
```
### keywords
-MONTHNAME
+ MONTHNAME
diff --git a/docs/en/docs/sql-manual/sql-functions/date-time-functions/now.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/now.md
index 1a572a60d4..a28419def2 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/now.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/now.md
@@ -66,4 +66,4 @@ Note:
2. Limited by the JDK implementation, if you use jdk8 to build FE, the
precision can be up to milliseconds (three decimal places), and the larger
precision bits will be filled with 0. If you need higher accuracy, please use
jdk11 to build FE.
### keywords
-NOW
+ NOW
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/second.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/second.md
index fc8a7938eb..af93797b5e 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/second.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/second.md
@@ -45,4 +45,4 @@ mysql> select second('2018-12-31 23:59:59');
+-----------------------------+
```
### keywords
-SECOND
+ SECOND
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/time_round.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/time_round.md
index f6a7539642..be2fa25672 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/time_round.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/time_round.md
@@ -83,4 +83,4 @@ MySQL> SELECT MONTH_CEIL(CAST('2020-02-02 13:09:20' AS
DATETIME), 3, CAST('1970-
```
### keywords
-TIME_ROUND
+ TIME_ROUND
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/timediff.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/timediff.md
index 9862c1af7a..e1457f8175 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/timediff.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/timediff.md
@@ -62,4 +62,4 @@ mysql> SELECT TIMEDIFF('2019-01-01 00:00:00', NULL);
+---------------------------------------+
```
### keywords
-TIMEDIFF
+ TIMEDIFF
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/timestampadd.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/timestampadd.md
index 88b7f4cf46..84541fa86e 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/timestampadd.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/timestampadd.md
@@ -55,4 +55,4 @@ mysql> SELECT TIMESTAMPADD(WEEK,1,'2019-01-02');
+----------------------------------------------+
```
### keywords
-TIMESTAMPADD
+ TIMESTAMPADD
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/timestampdiff.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/timestampdiff.md
index 16ee64762f..9a11896ec8 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/timestampdiff.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/timestampdiff.md
@@ -64,4 +64,4 @@ MySQL> SELECT TIMESTAMPDIFF(MINUTE,'2003-02-01','2003-05-01
12:05:55');
```
### keywords
-TIMESTAMPDIFF
+ TIMESTAMPDIFF
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/to_days.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/to_days.md
index d54c34a5ab..c0dedfe3b6 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/to_days.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/to_days.md
@@ -47,4 +47,4 @@ mysql> select to_days('2007-10-07');
```
### keywords
-TO_DAYS,TO,DAYS
+ TO_DAYS,TO,DAYS
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/utc_timestamp.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/utc_timestamp.md
index e173c3dedb..143fcc2a4e 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/utc_timestamp.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/utc_timestamp.md
@@ -46,5 +46,6 @@ mysql> select utc_timestamp(),utc_timestamp() + 1;
+---------------------+---------------------+
| 2019-07-10 12:31:18 | 20190710123119 |
+---------------------+---------------------+
+```
### keywords
-UTC_TIMESTAMP,UTC,TIMESTAMP
+ UTC_TIMESTAMP,UTC,TIMESTAMP
diff --git a/docs/en/docs/sql-manual/sql-functions/date-time-functions/week.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/week.md
index ef23d174f8..2943e45f85 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/week.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/week.md
@@ -64,4 +64,4 @@ mysql> select week('2020-7-1',1);
+---------------------+
```
### keywords
-WEEK
+ WEEK
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/weekday.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/weekday.md
index 1c94a62635..5666155a81 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/weekday.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/weekday.md
@@ -63,4 +63,4 @@ mysql> select weekday(cast(20190625 as date));
+---------------------------------+
```
### keywords
-WEEKDAY
\ No newline at end of file
+ WEEKDAY
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/weekofyear.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/weekofyear.md
index 43385eda34..b340a242eb 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/weekofyear.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/weekofyear.md
@@ -47,4 +47,4 @@ mysql> select weekofyear('2008-02-20 00:00:00');
+-----------------------------------+
```
### keywords
-WEEKOFYEAR
+ WEEKOFYEAR
diff --git a/docs/en/docs/sql-manual/sql-functions/date-time-functions/year.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/year.md
index 84c687286c..063e5e8cd9 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/year.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/year.md
@@ -47,4 +47,4 @@ mysql> select year('1987-01-01');
+-----------------------------+
```
### keywords
-YEAR
+ YEAR
diff --git
a/docs/en/docs/sql-manual/sql-functions/date-time-functions/yearweek.md
b/docs/en/docs/sql-manual/sql-functions/date-time-functions/yearweek.md
index b5358bcf91..f7107749e6 100644
--- a/docs/en/docs/sql-manual/sql-functions/date-time-functions/yearweek.md
+++ b/docs/en/docs/sql-manual/sql-functions/date-time-functions/yearweek.md
@@ -36,6 +36,7 @@ When the week of the date belongs to the previous year, the
year and week of the
when the week of the date belongs to the next year, the year of the next year
is returned and the week is 1.
The following table describes how the mode argument works.
+
|Mode |First day of week |Range |Week 1 is the first week … |
|:----|:-----------------|:-------|:-----------------------------|
|0 |Sunday |1-53 |with a Sunday in this year |
@@ -76,4 +77,4 @@ mysql> select yearweek('2024-12-30',1);
```
### keywords
-YEARWEEK
+ YEARWEEK
diff --git
a/docs/en/docs/sql-manual/sql-functions/string-functions/append_trailing_char_if_absent.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/append_trailing_char_if_absent.md
index 616f418d37..b97b503cb2 100644
---
a/docs/en/docs/sql-manual/sql-functions/string-functions/append_trailing_char_if_absent.md
+++
b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/ascii.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/ascii.md
index 41e77177f5..29e3dbc095 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/ascii.md
+++ b/docs/en/docs/sql-manual/sql-functions/string-functions/ascii.md
@@ -51,4 +51,4 @@ mysql> select ascii('234');
+--------------+
```
### keywords
-ASCII
+ ASCII
diff --git
a/docs/en/docs/sql-manual/sql-functions/string-functions/bit_length.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/bit_length.md
index 287c6fc97f..861a6b2259 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/bit_length.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/char_length.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/char_length.md
index 268d69ee58..924466eeeb 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/char_length.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/concat.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/concat.md
index f5a662e314..9799296136 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/concat.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/concat_ws.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/concat_ws.md
index a8a4f57d4b..7a0bc3ae13 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/concat_ws.md
+++ b/docs/en/docs/sql-manual/sql-functions/string-functions/concat_ws.md
@@ -82,4 +82,4 @@ mysql> select concat_ws("or", ["d", NULL,"is"]);
+-----------------------------------------+
```
### keywords
-CONCAT_WS,CONCAT,WS,ARRAY
+ CONCAT_WS,CONCAT,WS,ARRAY
diff --git a/docs/en/docs/sql-manual/sql-functions/string-functions/elt.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/elt.md
index 04667457a1..ffb6a07193 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/elt.md
+++ b/docs/en/docs/sql-manual/sql-functions/string-functions/elt.md
@@ -59,4 +59,4 @@ mysql> select elt(2, 'aaa', 'bbb');
+-----------------------+
```
### keywords
-ELT
\ No newline at end of file
+ ELT
diff --git
a/docs/en/docs/sql-manual/sql-functions/string-functions/ends_with.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/ends_with.md
index 38a297dc64..b5ed6c0ac9 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/ends_with.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/find_in_set.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/find_in_set.md
index 08eabc2a65..c51e078fcb 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/find_in_set.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/hex.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/hex.md
index 6a74fa3c4c..6041a50641 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/hex.md
+++ b/docs/en/docs/sql-manual/sql-functions/string-functions/hex.md
@@ -82,4 +82,4 @@ mysql> select hex(-1);
+------------------+
```
### keywords
-HEX
+ HEX
diff --git a/docs/en/docs/sql-manual/sql-functions/string-functions/instr.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/instr.md
index 01132b84d7..f9c160a3ce 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/instr.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/lcase.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/lcase.md
index 48c295ee85..3f3ee92eff 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/lcase.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/left.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/left.md
index 88122b874e..bdf5789c9a 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/left.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/length.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/length.md
index 7870b8cf15..891fbcdeb1 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/length.md
+++ b/docs/en/docs/sql-manual/sql-functions/string-functions/length.md
@@ -51,4 +51,4 @@ mysql> select length("中国");
+------------------+
```
### keywords
-LENGTH
+ LENGTH
diff --git
a/docs/en/docs/sql-manual/sql-functions/string-functions/like/like.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/like/like.md
index d357312c4e..6524a164fa 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/like/like.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/like/not_like.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/like/not_like.md
index 2d3e846230..1bc97cca20 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/like/not_like.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/locate.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/locate.md
index aa99d7423a..bab5940c76 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/locate.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/lower.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/lower.md
index f85cf4a2c5..81ca6fb451 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/lower.md
+++ b/docs/en/docs/sql-manual/sql-functions/string-functions/lower.md
@@ -44,4 +44,4 @@ mysql> SELECT lower("AbC123");
+-----------------+
```
### keywords
-LOWER
+ LOWER
diff --git a/docs/en/docs/sql-manual/sql-functions/string-functions/lpad.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/lpad.md
index 50f3d679a6..2b478c3f1d 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/lpad.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/ltrim.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/ltrim.md
index 1c1fb218f4..a29c9814b9 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/ltrim.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/money_format.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/money_format.md
index f4f6c47307..b5ae2f246d 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/money_format.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/null_or_empty.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/null_or_empty.md
index 0c0d5d46d8..52f8734466 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/null_or_empty.md
+++ b/docs/en/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
diff --git
a/docs/en/docs/sql-manual/sql-functions/string-functions/find_in_set.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/parse_url.md
similarity index 58%
copy from docs/en/docs/sql-manual/sql-functions/string-functions/find_in_set.md
copy to docs/en/docs/sql-manual/sql-functions/string-functions/parse_url.md
index 08eabc2a65..cf6e662af4 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/find_in_set.md
+++ b/docs/en/docs/sql-manual/sql-functions/string-functions/parse_url.md
@@ -1,6 +1,6 @@
---
{
- "title": "find_in_set",
+ "title": "parse_url",
"language": "en"
}
---
@@ -24,26 +24,25 @@ 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)`
-"NOT found in set (VARCHAR str., VARCHAR strlist)"
-
-Return to the location where the str first appears in strlist (counting from
1). Strlist is a comma-separated string. If not, return 0. Any parameter is
NULL, returning NULL.
+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 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/docs/en/docs/sql-manual/sql-functions/string-functions/regexp/not_regexp.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/regexp/not_regexp.md
index ca2e19f4b8..c5d267568d 100644
---
a/docs/en/docs/sql-manual/sql-functions/string-functions/regexp/not_regexp.md
+++
b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/regexp/regexp.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/regexp/regexp.md
index 41a1a239f8..0f0b1d338c 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/regexp/regexp.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/regexp/regexp_extract.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/regexp/regexp_extract.md
index 814605beca..e2d59ee446 100644
---
a/docs/en/docs/sql-manual/sql-functions/string-functions/regexp/regexp_extract.md
+++
b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/regexp/regexp_replace.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/regexp/regexp_replace.md
index e9b611f649..05ec3777b8 100644
---
a/docs/en/docs/sql-manual/sql-functions/string-functions/regexp/regexp_replace.md
+++
b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/repeat.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/repeat.md
index ada0b7b3eb..cfb826cc6a 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/repeat.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/replace.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/replace.md
index b9946bf83b..e036597b07 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/replace.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/reverse.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/reverse.md
index 797041bff5..c01ae08b59 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/reverse.md
+++ b/docs/en/docs/sql-manual/sql-functions/string-functions/reverse.md
@@ -83,4 +83,4 @@ mysql> select k1, k2, reverse(k2) from array_test01 order by
k1;
+------+-----------------------------------+-----------------------------------+
```
### keywords
-REVERSE, ARRAY
+ REVERSE, ARRAY
diff --git a/docs/en/docs/sql-manual/sql-functions/string-functions/right.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/right.md
index 506949d6d8..cf5499a4c8 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/right.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/rpad.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/rpad.md
index ffd97f5337..310464c1d5 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/rpad.md
+++ b/docs/en/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/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ltrim.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/rtrim.md
similarity index 76%
copy from docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ltrim.md
copy to docs/en/docs/sql-manual/sql-functions/string-functions/rtrim.md
index 003756d829..fb2752bef1 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ltrim.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/split_part.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/split_part.md
index 3261ca9082..67a7bc721a 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/split_part.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/starts_with.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/starts_with.md
index 10fbf1c40b..691022c0c0 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/starts_with.md
+++ b/docs/en/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
diff --git a/docs/en/docs/sql-manual/sql-functions/string-functions/strleft.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/strleft.md
index 4049b4d892..843560bfac 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/strleft.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/strright.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/strright.md
index 49d08851f3..68fee0190b 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/strright.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/substr.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/substr.md
index 11deb853fd..60dcac4975 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/substr.md
+++ b/docs/en/docs/sql-manual/sql-functions/string-functions/substr.md
@@ -47,4 +47,4 @@ mysql> select substr("Hello doris", 1, 2);
+-----------------------------+
```
### keywords
-SUBSTR
+ SUBSTR
diff --git
a/docs/en/docs/sql-manual/sql-functions/string-functions/substring.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/substring.md
index 78064b8aa2..7a65cb15c2 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/substring.md
+++ b/docs/en/docs/sql-manual/sql-functions/string-functions/substring.md
@@ -82,4 +82,4 @@ mysql> select substring('abc1def', 2, 2);
```
### keywords
-SUBSTRING, STRING
+ SUBSTRING, STRING
diff --git a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ltrim.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/trim.md
similarity index 77%
copy from docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ltrim.md
copy to docs/en/docs/sql-manual/sql-functions/string-functions/trim.md
index 003756d829..c6b8034fe4 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ltrim.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/lcase.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/ucase.md
similarity index 88%
copy from docs/en/docs/sql-manual/sql-functions/string-functions/lcase.md
copy to docs/en/docs/sql-manual/sql-functions/string-functions/ucase.md
index 48c295ee85..cf2879d095 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/lcase.md
+++ b/docs/en/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/en/docs/sql-manual/sql-functions/string-functions/unhex.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/unhex.md
index 42bd20f762..fb66dc43e1 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/unhex.md
+++ b/docs/en/docs/sql-manual/sql-functions/string-functions/unhex.md
@@ -60,4 +60,4 @@ mysql> select unhex('4142');
+---------------+
```
### keywords
-UNHEX
+ UNHEX
diff --git a/docs/en/docs/sql-manual/sql-functions/string-functions/lower.md
b/docs/en/docs/sql-manual/sql-functions/string-functions/upper.md
similarity index 81%
copy from docs/en/docs/sql-manual/sql-functions/string-functions/lower.md
copy to docs/en/docs/sql-manual/sql-functions/string-functions/upper.md
index f85cf4a2c5..14a4ed5e1d 100644
--- a/docs/en/docs/sql-manual/sql-functions/string-functions/lower.md
+++ b/docs/en/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/docs/sidebars.json b/docs/sidebars.json
index 39712c24f7..38f1a24425 100644
--- a/docs/sidebars.json
+++ b/docs/sidebars.json
@@ -346,37 +346,43 @@
"type": "category",
"label": "String Functions",
"items": [
-
"sql-manual/sql-functions/string-functions/concat_ws",
-
"sql-manual/sql-functions/string-functions/hex",
-
"sql-manual/sql-functions/string-functions/lower",
+
"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/substring",
-
"sql-manual/sql-functions/string-functions/instr",
-
"sql-manual/sql-functions/string-functions/repeat",
-
"sql-manual/sql-functions/string-functions/lcase",
-
"sql-manual/sql-functions/string-functions/replace",
"sql-manual/sql-functions/string-functions/rpad",
-
"sql-manual/sql-functions/string-functions/split_part",
+
"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/substr",
+
"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/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/elt",
+
"sql-manual/sql-functions/string-functions/instr",
+
"sql-manual/sql-functions/string-functions/locate",
+
"sql-manual/sql-functions/string-functions/find_in_set",
+
"sql-manual/sql-functions/string-functions/replace",
"sql-manual/sql-functions/string-functions/left",
-
"sql-manual/sql-functions/string-functions/starts_with",
-
"sql-manual/sql-functions/string-functions/concat",
-
"sql-manual/sql-functions/string-functions/bit_length",
+
"sql-manual/sql-functions/string-functions/right",
"sql-manual/sql-functions/string-functions/strleft",
"sql-manual/sql-functions/string-functions/strright",
+
"sql-manual/sql-functions/string-functions/split_part",
"sql-manual/sql-functions/string-functions/money_format",
-
"sql-manual/sql-functions/string-functions/right",
-
"sql-manual/sql-functions/string-functions/substr",
-
"sql-manual/sql-functions/string-functions/find_in_set",
-
"sql-manual/sql-functions/string-functions/ascii",
-
"sql-manual/sql-functions/string-functions/reverse",
-
"sql-manual/sql-functions/string-functions/length",
-
"sql-manual/sql-functions/string-functions/unhex",
-
"sql-manual/sql-functions/string-functions/ends_with",
-
"sql-manual/sql-functions/string-functions/char_length",
-
"sql-manual/sql-functions/string-functions/null_or_empty",
-
"sql-manual/sql-functions/string-functions/locate",
+
"sql-manual/sql-functions/string-functions/parse_url",
{
"type": "category",
"label": "Fuzzy Match",
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/day.md
b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/day.md
index f980840af9..aa7ab5567c 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/day.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/day.md
@@ -46,4 +46,4 @@ mysql> select day('1987-01-31');
+----------------------------+
```
### keywords
-DAY
+ DAY
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/hour.md
b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/hour.md
index 81343b95ee..70d87624f5 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/hour.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/hour.md
@@ -46,4 +46,4 @@ mysql> select hour('2018-12-31 23:59:59');
+-----------------------------+
```
### keywords
-HOUR
+ HOUR
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/makedate.md
b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/makedate.md
index 336f5e4c61..67f556f86a 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/makedate.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/makedate.md
@@ -29,6 +29,7 @@ under the License.
#### Syntax
`DATE MAKEDATE(INT year, INT dayofyear)`
+
返回指定年份和dayofyear构建的日期。dayofyear必须大于0，否则结果为空。
### example
@@ -43,4 +44,4 @@ mysql> select makedate(2021,1), makedate(2021,100),
makedate(2021,400);
### keywords
- YEARWEEK
+ MAKEDATE
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/minute.md
b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/minute.md
index 380e9228d1..1a23f318c9 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/minute.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/minute.md
@@ -46,4 +46,4 @@ mysql> select minute('2018-12-31 23:59:59');
+-----------------------------+
```
### keywords
-MINUTE
+ MINUTE
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/second.md
b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/second.md
index 818a8be0c5..141aecfc49 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/second.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/second.md
@@ -46,4 +46,4 @@ mysql> select second('2018-12-31 23:59:59');
+-----------------------------+
```
### keywords
-SECOND
+ SECOND
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/time_round.md
b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/time_round.md
index 60812dc1b6..5cfb9255a4 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/time_round.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/time_round.md
@@ -83,4 +83,4 @@ MySQL> SELECT MONTH_CEIL(CAST('2020-02-02 13:09:20' AS
DATETIME), 3, CAST('1970-
```
### keywords
-TIME_ROUND
+ TIME_ROUND
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/timestampadd.md
b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/timestampadd.md
index f30d50e2cf..ceccf80569 100644
---
a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/timestampadd.md
+++
b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/timestampadd.md
@@ -56,4 +56,4 @@ mysql> SELECT TIMESTAMPADD(WEEK,1,'2019-01-02');
+----------------------------------------------+
```
### keywords
-TIMESTAMPADD
+ TIMESTAMPADD
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/timestampdiff.md
b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/timestampdiff.md
index 7edbea2dc4..c1e264ad66 100644
---
a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/timestampdiff.md
+++
b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/timestampdiff.md
@@ -64,4 +64,4 @@ MySQL> SELECT TIMESTAMPDIFF(MINUTE,'2003-02-01','2003-05-01
12:05:55');
```
### keywords
-TIMESTAMPDIFF
+ TIMESTAMPDIFF
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/weekday.md
b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/weekday.md
index 535727cd7f..4b9a237d30 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/weekday.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/weekday.md
@@ -65,4 +65,4 @@ mysql> select weekday(cast(20190625 as date));
```
### keywords
-WEEKDAY
+ WEEKDAY
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/yearweek.md
b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/yearweek.md
index 87b5dcf575..d6fe511278 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/yearweek.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/yearweek.md
@@ -35,6 +35,7 @@ under the License.
当日期所在的星期属于上一年时，返回的是上一年的年份和星期数；
当日期所在的星期属于下一年时，返回的是下一年的年份，星期数为1。
参数mode的作用参见下面的表格：
+
|Mode |星期的第一天 |星期数的范围 |第一个星期的定义 |
|:----|:------------|:------------|:--------------------------------------------|
|0 |星期日 |1-53 |这一年中的第一个星期日所在的星期 |
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/append_trailing_char_if_absent.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/append_trailing_char_if_absent.md
index 43ca0c12c0..dd031e0731 100644
---
a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/append_trailing_char_if_absent.md
+++
b/docs/zh-CN/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/zh-CN/docs/sql-manual/sql-functions/string-functions/ascii.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ascii.md
index cef492b75c..31b08c8fcb 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ascii.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ascii.md
@@ -51,4 +51,4 @@ mysql> select ascii('234');
+--------------+
```
### keywords
-ASCII
+ ASCII
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/bit_length.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/bit_length.md
index ce294cfcbf..d50ef0b201 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/bit_length.md
+++ b/docs/zh-CN/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/zh-CN/docs/sql-manual/sql-functions/string-functions/char_length.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/char_length.md
index f0ee2ff17e..cf8b64f123 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/char_length.md
+++ b/docs/zh-CN/docs/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/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/concat.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/concat.md
index 01bd503fd5..c68e256343 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/concat.md
+++ b/docs/zh-CN/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/zh-CN/docs/sql-manual/sql-functions/string-functions/concat_ws.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/concat_ws.md
index a21d1b3ba5..9d95065445 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/concat_ws.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/concat_ws.md
@@ -82,4 +82,4 @@ mysql> select concat_ws("or", ["d", NULL,"is"]);
+-----------------------------------------+
```
### keywords
-CONCAT_WS,CONCAT,WS,ARRAY
+ CONCAT_WS,CONCAT,WS,ARRAY
diff --git a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/elt.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/elt.md
index f61f1e1abe..47472a1cbc 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/elt.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/elt.md
@@ -59,4 +59,4 @@ mysql> select elt(2, 'aaa', 'bbb');
+-----------------------+
```
### keywords
-ELT
\ No newline at end of file
+ ELT
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ends_with.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ends_with.md
index a654631384..f289803d81 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ends_with.md
+++ b/docs/zh-CN/docs/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/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/find_in_set.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/find_in_set.md
index 25fa21d4d3..38e3dd456f 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/find_in_set.md
+++ b/docs/zh-CN/docs/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/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/hex.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/hex.md
index 6d2893789e..b15ceaa2f8 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/hex.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/hex.md
@@ -82,4 +82,4 @@ mysql> select hex(-1);
+------------------+
```
### keywords
-HEX
+ HEX
diff --git a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/instr.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/instr.md
index 2aa8936858..b3b7e0155f 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/instr.md
+++ b/docs/zh-CN/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/zh-CN/docs/sql-manual/sql-functions/string-functions/lcase.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/lcase.md
index 7edd3cc1c5..61a9598403 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/lcase.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/lcase.md
@@ -34,4 +34,4 @@ under the License.
与`lower`一致
### keywords
-LCASE
+ LCASE
diff --git a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/left.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/left.md
index 1cf5131923..357f0e1cd2 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/left.md
+++ b/docs/zh-CN/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/zh-CN/docs/sql-manual/sql-functions/string-functions/length.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/length.md
index b83373811d..f9c9499c42 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/length.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/length.md
@@ -51,4 +51,4 @@ mysql> select length("中国");
+------------------+
```
### keywords
-LENGTH
+ LENGTH
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/like/like.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/like/like.md
index 223fd22073..06bdaf2dab 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/like/like.md
+++ b/docs/zh-CN/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/zh-CN/docs/sql-manual/sql-functions/string-functions/like/not_like.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/like/not_like.md
index 7d6fba9ab0..c7efbb8f41 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/like/not_like.md
+++ b/docs/zh-CN/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/zh-CN/docs/sql-manual/sql-functions/string-functions/locate.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/locate.md
index aa0adf2146..c7a85e20cd 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/locate.md
+++ b/docs/zh-CN/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/zh-CN/docs/sql-manual/sql-functions/string-functions/lower.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/lower.md
index 5d6d0da4f6..177b22572a 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/lower.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/lower.md
@@ -44,4 +44,4 @@ mysql> SELECT lower("AbC123");
+-----------------+
```
### keywords
-LOWER
+ LOWER
diff --git a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/lpad.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/lpad.md
index d94f44082e..5eb72465fe 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/lpad.md
+++ b/docs/zh-CN/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/zh-CN/docs/sql-manual/sql-functions/string-functions/ltrim.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ltrim.md
index 003756d829..ae7e415b3e 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ltrim.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ltrim.md
@@ -31,17 +31,17 @@ under the License.
`VARCHAR ltrim(VARCHAR str)`
-将参数 str 中从开始部分连续出现的空格去掉
+将参数 str 中从左侧部分开始部分连续出现的空格去掉
### example
```
-mysql> SELECT ltrim(' ab d');
-+------------------+
-| ltrim(' ab d') |
-+------------------+
-| ab d |
-+------------------+
+mysql> SELECT ltrim(' ab d') str;
++------+
+| str |
++------+
+| ab d |
++------+
```
### keywords
-LTRIM
+ LTRIM
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/money_format.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/money_format.md
index d4faebd934..0470807f0b 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/money_format.md
+++ b/docs/zh-CN/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/zh-CN/docs/sql-manual/sql-functions/string-functions/null_or_empty.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/null_or_empty.md
index 9f8ccd3ce5..e05e10d50f 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/null_or_empty.md
+++ b/docs/zh-CN/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
+ NULL_OR_EMPTY
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/second.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/parse_url.md
similarity index 59%
copy from docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/second.md
copy to docs/zh-CN/docs/sql-manual/sql-functions/string-functions/parse_url.md
index 818a8be0c5..dd25203b14 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/date-time-functions/second.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/parse_url.md
@@ -1,6 +1,6 @@
---
{
- "title": "second",
+ "title": "parse_url",
"language": "zh-CN"
}
---
@@ -24,26 +24,23 @@ specific language governing permissions and limitations
under the License.
-->
-## second
+## parse_url
### description
#### Syntax
-`INT SECOND(DATETIME date)`
+`VARCHAR parse_url(VARCHAR url, VARCHAR name)`
-获得日期中的秒的信息，返回值范围从0-59。
-
-参数为Date或者Datetime类型
-
-### example
+在url解析出name对应的字段，name可选项为：'PROTOCOL', 'HOST', 'PATH', 'REF', 'AUTHORITY',
'FILE', 'USERINFO', 'PORT', 'QUERY'，将结果返回。
```
-mysql> select second('2018-12-31 23:59:59');
-+-----------------------------+
-| second('2018-12-31 23:59:59') |
-+-----------------------------+
-| 59 |
-+-----------------------------+
+mysql> SELECT parse_url ('https://doris.apache.org/', 'HOST');
++------------------------------------------------+
+| parse_url('https://doris.apache.org/', 'HOST') |
++------------------------------------------------+
+| doris.apache.org |
++------------------------------------------------+
```
+
### keywords
-SECOND
+ PARSE URL
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/regexp/not_regexp.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/regexp/not_regexp.md
index 5f07c92777..7e7bb278c5 100644
---
a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/regexp/not_regexp.md
+++
b/docs/zh-CN/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/zh-CN/docs/sql-manual/sql-functions/string-functions/regexp/regexp.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/regexp/regexp.md
index b42d7278d3..f4e690c08c 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/regexp/regexp.md
+++ b/docs/zh-CN/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/zh-CN/docs/sql-manual/sql-functions/string-functions/regexp/regexp_extract.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/regexp/regexp_extract.md
index f1fbaaf882..275113672c 100644
---
a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/regexp/regexp_extract.md
+++
b/docs/zh-CN/docs/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/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/regexp/regexp_replace.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/regexp/regexp_replace.md
index 76e748cc4f..df3e654478 100644
---
a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/regexp/regexp_replace.md
+++
b/docs/zh-CN/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/zh-CN/docs/sql-manual/sql-functions/string-functions/repeat.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/repeat.md
index b4b8a579ec..def735035b 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/repeat.md
+++ b/docs/zh-CN/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/zh-CN/docs/sql-manual/sql-functions/string-functions/replace.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/replace.md
index 9b317291b5..4b88f11868 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/replace.md
+++ b/docs/zh-CN/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/zh-CN/docs/sql-manual/sql-functions/string-functions/reverse.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/reverse.md
index 37a8bdad4f..ebc8b845dc 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/reverse.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/reverse.md
@@ -1,6 +1,6 @@
---
{
- "title": "REVERSE",
+ "title": "reverse",
"language": "zh-CN"
}
---
@@ -83,4 +83,4 @@ mysql> select k1, k2, reverse(k2) from array_test01 order by
k1;
+------+-----------------------------------+-----------------------------------+
```
### keywords
-REVERSE, ARRAY
+ REVERSE, ARRAY
diff --git a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/right.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/right.md
index ec8d1bf42d..f820a08ad6 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/right.md
+++ b/docs/zh-CN/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/zh-CN/docs/sql-manual/sql-functions/string-functions/rpad.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/rpad.md
index f7361efd73..2bd4ce329f 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/rpad.md
+++ b/docs/zh-CN/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/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ltrim.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/rtrim.md
similarity index 78%
copy from docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ltrim.md
copy to docs/zh-CN/docs/sql-manual/sql-functions/string-functions/rtrim.md
index 003756d829..9774fe6035 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ltrim.md
+++ b/docs/zh-CN/docs/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/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/split_part.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/split_part.md
index 204a202c32..00e5620f53 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/split_part.md
+++ b/docs/zh-CN/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/zh-CN/docs/sql-manual/sql-functions/string-functions/starts_with.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/starts_with.md
index e6a7308b11..9219eb9a38 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/starts_with.md
+++ b/docs/zh-CN/docs/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/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/strleft.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/strleft.md
index 47f3cd967c..78473b5720 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/strleft.md
+++ b/docs/zh-CN/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/zh-CN/docs/sql-manual/sql-functions/string-functions/strright.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/strright.md
index 10b090f864..21ad8120f1 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/strright.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/strright.md
@@ -44,4 +44,4 @@ mysql> select strright("Hello doris",5);
+-------------------------+
```
### keywords
-STRRIGHT
+ STRRIGHT
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/substr.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/substr.md
index 02ac2b8631..7b3b6e0ca0 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/substr.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/substr.md
@@ -47,4 +47,4 @@ mysql> select substr("Hello doris", 1, 2);
+-----------------------------+
```
### keywords
-SUBSTR
+ SUBSTR
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/substring.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/substring.md
index 21abea7a50..b172ba3c44 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/substring.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/substring.md
@@ -76,4 +76,4 @@ mysql> select substring('abc1def', 2, 2);
+-----------------------------+
```
### keywords
-SUBSTRING, STRING
+ SUBSTRING, STRING
diff --git a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ltrim.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/trim.md
similarity index 79%
copy from docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ltrim.md
copy to docs/zh-CN/docs/sql-manual/sql-functions/string-functions/trim.md
index 003756d829..c6c5e1b67b 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ltrim.md
+++ b/docs/zh-CN/docs/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/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/lcase.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ucase.md
similarity index 91%
copy from docs/zh-CN/docs/sql-manual/sql-functions/string-functions/lcase.md
copy to docs/zh-CN/docs/sql-manual/sql-functions/string-functions/ucase.md
index 7edd3cc1c5..7b663bd46a 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/lcase.md
+++ b/docs/zh-CN/docs/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/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/unhex.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/unhex.md
index 28b50e966c..8f4aa12329 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/unhex.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/unhex.md
@@ -60,4 +60,4 @@ mysql> select unhex('4142');
+---------------+
```
### keywords
-UNHEX
+ UNHEX
diff --git a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/lower.md
b/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/upper.md
similarity index 83%
copy from docs/zh-CN/docs/sql-manual/sql-functions/string-functions/lower.md
copy to docs/zh-CN/docs/sql-manual/sql-functions/string-functions/upper.md
index 5d6d0da4f6..953b646ad0 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/string-functions/lower.md
+++ b/docs/zh-CN/docs/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
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
