yiguolei commented on code in PR #2568: URL: https://github.com/apache/doris-website/pull/2568#discussion_r2184306289
########## docs/sql-manual/sql-functions/scalar-functions/string-functions/regexp-replace.md: ########## @@ -40,35 +39,147 @@ REGEXP_REPLACE(<str>, <pattern>, <repl>) | Parameter | Description | | -- | -- | -| `<str>` | The column need to do regular matching.| -| `<pattern>` | Target pattern.| -| `<repl>` | The string to replace the matched pattern.| +| `<str>` | This parameter is of Varchar type. It represents the string on which the regular expression matching will be performed. It can be a literal string or a column from a table containing string values.| +| `<pattern>` | This parameter is of Varchar type. It is the regular expression pattern used to match the string. The pattern can include various regular expression metacharacters and constructs to define complex matching rules.| +| `<repl>` | This parameter is of Varchar type. It is the string that will replace the parts of the <str> that match the <pattern>. If you want to reference captured groups in the pattern, you can use backreferences like \1, \2, etc., where \1 refers to the first captured group, \2 refers to the second captured group, and so on.| ## Return Value -Result after doing replacement. It is `Varchar` type. +The function returns the result string after the replacement operation. The return value is of Varchar type. If no part of the <str> matches the <pattern>, the original <str> will be returned. Review Comment: 这3个参数,分别为null的时候,是什么结果。 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
