\u672c\u6587\u6c47\u603bGBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\u7684\u5b57\u7b26\u4e32\uff0c\u65e5\u671f\u51fd\u6570\uff0c\u63d0\u4f9b\u5bf9\u5e94\u7684\u8be6\u7ec6\u4ecb\u7ecd\u8fde\u63a5\u3002<\/p>\n\n\n\n
\u76ee\u5f55\u5bfc\u822a<\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/label>\u53c2\u8003<\/a><\/li>ASCII(str)<\/a><\/li>BIN(N)<\/a><\/li>BIT_LENGTH(str)<\/a><\/li>CHAR(N1,N2\u2026)<\/a><\/li>CHAR_LENGTH(str)<\/a><\/li>CHARACTER_LENGTH(str)<\/a><\/li>CONCAT<\/a><\/li>current_date<\/a><\/li>current_datetime<\/a><\/li>current_time<\/a><\/li>current_timestamp<\/a><\/li>CONV<\/a><\/li>DAYOFWEEK<\/a><\/li>ELT<\/a><\/li>FIELD<\/a><\/li>FIND_IN_SET(str,strlist)<\/a><\/li>HEX(N_or_S)<\/a><\/li>IF(expr1,expr2,expr3)<\/a><\/li>IFNULL(expr1,expr2)<\/a><\/li>insert(str,pos,len,newstr)<\/a><\/li>INSTR(str,substr,start_position,nth_appearance)<\/a><\/li>LENGTH(str)<\/a><\/li>LTRIM(str)<\/a><\/li>MAKEDATE<\/a><\/li>MICROSECOND(expr)<\/a><\/li>MID(str,pos,len)<\/a><\/li>NOW()<\/a><\/li>NULLIF(expr1,expr2)<\/a><\/li>REGEXP_LIKE(source_char, pattern [, match_parameter])<\/a><\/li>regexp_instr()<\/a><\/li>regexp_replace()<\/a><\/li>replace(str,from_str,to_str)<\/a><\/li>RTRIM(str)<\/a><\/li>SUBSTR<\/a><\/li>SUBSTRING<\/a><\/li>sysdate<\/a><\/li>TO_NUMBER(expr)<\/a><\/li>TO_DATE(str)<\/a><\/li>TRIM([{BOTH | LEADING | TRAILING} [trim_char] FROM] str)<\/a><\/li>utc_date<\/a><\/li>utc_datetime<\/a><\/li>utc_time<\/a><\/li>utc_timestamp<\/a><\/li>week(date, mode)<\/a><\/li>weekday<\/a><\/li>weekofyear<\/a><\/li>YEARWEEK<\/a><\/li><\/ul><\/nav><\/div>\n<\/span>\u53c2\u8003<\/span><\/h2>\n\n\n\nGBase 8a\u7a97\u53e3\u51fd\u6570\u4f7f\u7528\u6837\u4f8b\u7d22\u5f15<\/a><\/p>\n\n\n\n<\/span>ASCII(str)<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de\u5b57\u7b26\u4e32 str \u9996\u5b57\u7b26\u7684 ASCII \u7801\u503c\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>BIN(N)<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de N \u7684\u4e8c\u8fdb\u5236\u5f62\u5f0f<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>BIT_LENGTH(str)<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de\u5b57\u7b26\u4e32 str \u7684\u6bd4\u7279\u957f\u5ea6\uff0c\u4ee5\u6bd4\u7279\u8fdb\u884c\u8ba1\u7b97\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>CHAR(N1,N2\u2026)<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de\u76f8\u5e94\u4ee3\u8868\u7684 ASCII \u7801\u503c\u5bf9\u5e94\u7684\u5b57\u7b26\u7ec4\u6210\u7684\u5b57\u7b26\u4e32\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>CHAR_LENGTH(str)<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de\u5b57\u7b26\u4e32 str \u7684\u5b57\u7b26\u957f\u5ea6\uff0c\u4ee5\u5b57\u7b26\u4e2a\u6570\u4e3a\u5355\u4f4d\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>CHARACTER_LENGTH(str)<\/a><\/span><\/h2>\n\n\n\n\u4e0echar_length\u5b8c\u5168\u4e00\u6837\uff0c\u8fd4\u56de\u5b57\u7b26\u4e32 str \u7684\u5b57\u7b26\u957f\u5ea6\uff0c\u4ee5\u5b57\u7b26\u4e2a\u6570\u4e3a\u5355\u4f4d\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>CONCAT<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de\u7ed3\u679c\u4e3a\u8fde\u63a5\u53c2\u6570\u4ea7\u751f\u7684\u5b57\u7b26\u4e32\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>current_date<\/a><\/span><\/h2>\n\n\n\n\u5f53\u524d\u65e5\u671f\uff0c\u4e0d\u5305\u542b\u65f6\u95f4\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>current_datetime<\/a><\/span><\/h2>\n\n\n\n\u5f53\u524d\u65e5\u671f\u65f6\u95f4\uff0c\u5305\u542b\u6beb\u79d2\uff0c\u5fae\u79d2\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>current_time<\/a><\/span><\/h2>\n\n\n\n\u5f53\u524d\u65f6\u95f4<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>current_timestamp<\/a><\/span><\/h2>\n\n\n\n\u5f53\u524d\u65f6\u95f4\u6233\uff0c\u65e5\u671f\u548c\u65f6\u95f4\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>CONV<\/a><\/span><\/h2>\n\n\n\n\u4e0d\u540c\u6570\u5b57\u8fdb\u5236\u95f4\u7684\u8f6c\u6362<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>DAYOFWEEK<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de date (1 = \u5468\u65e5, 2 = \u5468\u4e00, \u2026, 7 = \u5468\u516d)\u5bf9\u5e94\u7684\u5de5\u4f5c\u65e5\u7d22\u5f15<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>ELT<\/a><\/span><\/h2>\n\n\n\n<\/p>\n\n\n\n<\/span>FIELD<\/a><\/span><\/h2>\n\n\n\n\u67e5\u627e\u5b57\u7b26\u4e32\u6240\u5728\u7684\u4f4d\u7f6e\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>FIND_IN_SET(str,strlist)<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de\u5b57\u7b26\u4e32 str \u5728 strlist \u4e2d\u5bf9\u5e94\u7684\u4f4d\u7f6e<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>HEX(N_or_S)<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de\u53c2\u6570\u5bf9\u5e94\u7684\u5341\u516d\u8fdb\u5236\u503c<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>IF(expr1,expr2,expr3)<\/a><\/span><\/h2>\n\n\n\n\u5982\u679c expr1 \u4e3a TRUE \u5219 IF()\u7684\u8fd4\u56de\u503c\u4e3a expr2\uff0c\u5982\u679c expr1 \u53d6\u503c\u4e3a FALSE\u30010 \u6216NULL\uff0c\u5219\u8fd4\u56de\u503c\u4e3a expr3\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>IFNULL(expr1,expr2)<\/a><\/span><\/h2>\n\n\n\n\u5982\u679c expr1 \u4e0d\u4e3a NULL\uff0c\u5219 IFNULL()\u7684\u8fd4\u56de\u503c\u4e3a expr1\uff0c\u5426\u5219\u5176\u8fd4\u56de\u503c\u4e3a expr2\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>insert(str,pos,len,newstr)<\/a><\/span><\/h2>\n\n\n\n\u5c06str\u5b57\u7b26\u4e32\uff0c\u4ece\u6307\u5b9a\u4f4d\u7f6epos\u5f00\u59cb\uff0c\u6307\u5b9a\u957f\u5ea6len\u7684\u5b57\u7b26\uff0c\u66ff\u6362\u6210newstr\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>INSTR(str,substr,start_position,nth_appearance)<\/a><\/span><\/h2>\n\n\n\n\u67e5\u627esubstr\u5728str\u4e2d\u51fa\u73b0\u7684\u5b57\u7b26\u4f4d\u7f6e\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>LENGTH(str)<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de\u5b57\u7b26\u4e32 str \u7684\u957f\u5ea6\uff0c\u4ee5\u5b57\u8282\u8fdb\u884c\u8ba1\u7b97\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>LTRIM(str)<\/a><\/span><\/h2>\n\n\n\n\u79fb\u9664\u5b57\u7b26\u4e32\u5de6\u4fa7\u5f00\u5934\u7684\u5168\u90e8\u7a7a\u683c<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>MAKEDATE<\/a><\/span><\/h2>\n\n\n\n\u7ed9\u51fa\u5e74\u4efd\u503c year \u548c\u4e00\u5e74\u4e2d\u7684\u5929\u6570\u503c dayofyear\uff0c\u8fd4\u56de\u65e5\u671f\u503c\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>MICROSECOND(expr)<\/a><\/span><\/h2>\n\n\n\n\u4ee5\u6570\u5b57\u7684\u5f62\u5f0f\u8fd4\u56de time \u6216\u8005 datetime \u8868\u8fbe\u5f0f expr \u4e2d\u7684\u5fae\u79d2\u503c<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>MID(str,pos,len)<\/a><\/span><\/h2>\n\n\n\n\u622a\u53d6\u6307\u5b9a\u4f4d\u7f6e\u5f00\u59cb\u7684\u6307\u5b9a\u957f\u7684\u7684\u5b57\u7b26\u4e32,\u4e8eSubstring(str,pos,len)\u5b8c\u5168\u4e00\u6837\u3002<\/p>\n\n\n\n<\/span>NOW()<\/a><\/span><\/h2>\n\n\n\n\u5f53\u524d\u65e5\u671f\u65f6\u95f4<\/p>\n\n\n\n<\/span>NULLIF(expr1,expr2)<\/a><\/span><\/h2>\n\n\n\n\u5982\u679c expr1 = expr2 \u6210\u7acb\uff0c\u8fd4\u56de\u503c\u4e3a NULL\uff0c\u5426\u5219\u8fd4\u56de\u503c\u4e3a expr1\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>REGEXP_LIKE(source_char, pattern [, match_parameter])<\/a><\/span><\/h2>\n\n\n\n\u6a21\u7cca\u5339\u914d\u6307\u5b9a\u7684\u5b57\u7b26\u4e32\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>regexp_instr()<\/a><\/span><\/h2>\n\n\n\n\u6b63\u5219\u83b7\u5f97\u5339\u914d\u5b57\u7b26\u4e32\u7684\u4f4d\u7f6e<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>regexp_replace()<\/a><\/span><\/h2>\n\n\n\n\u6b63\u5219\u66ff\u6362\u51fd\u6570<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>replace(str,from_str,to_str)<\/a><\/span><\/h2>\n\n\n\n\u5c06 str \u4e2d\u6240\u6709\u51fa\u73b0\u7684 from_str \u66ff\u6362\u4e3a to_str \u540e\u7684\u5b57\u7b26\u4e32<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>RTRIM(str)<\/a><\/span><\/h2>\n\n\n\n\u79fb\u9664\u5b57\u7b26\u4e32\u53f3\u4fa7\u7ed3\u5c3e\u7684\u5168\u90e8\u7a7a\u683c<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>SUBSTR<\/a><\/span><\/h2>\n\n\n\n\u622a\u53d6\u6307\u5b9a\u4f4d\u7f6e\u5f00\u59cb\u7684\u6307\u5b9a\u957f\u7684\u7684\u5b57\u7b26\u4e32\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>SUBSTRING<\/a><\/span><\/h2>\n\n\n\nSUBSTR\u7684\u5b8c\u6574\u540d\u5b57\u3002\u622a\u53d6\u6307\u5b9a\u4f4d\u7f6e\u5f00\u59cb\u7684\u6307\u5b9a\u957f\u7684\u7684\u5b57\u7b26\u4e32\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>
GBase 8a\u7a97\u53e3\u51fd\u6570\u4f7f\u7528\u6837\u4f8b\u7d22\u5f15<\/a><\/p>\n\n\n\n<\/span>ASCII(str)<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de\u5b57\u7b26\u4e32 str \u9996\u5b57\u7b26\u7684 ASCII \u7801\u503c\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>BIN(N)<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de N \u7684\u4e8c\u8fdb\u5236\u5f62\u5f0f<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>BIT_LENGTH(str)<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de\u5b57\u7b26\u4e32 str \u7684\u6bd4\u7279\u957f\u5ea6\uff0c\u4ee5\u6bd4\u7279\u8fdb\u884c\u8ba1\u7b97\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>CHAR(N1,N2\u2026)<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de\u76f8\u5e94\u4ee3\u8868\u7684 ASCII \u7801\u503c\u5bf9\u5e94\u7684\u5b57\u7b26\u7ec4\u6210\u7684\u5b57\u7b26\u4e32\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>CHAR_LENGTH(str)<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de\u5b57\u7b26\u4e32 str \u7684\u5b57\u7b26\u957f\u5ea6\uff0c\u4ee5\u5b57\u7b26\u4e2a\u6570\u4e3a\u5355\u4f4d\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>CHARACTER_LENGTH(str)<\/a><\/span><\/h2>\n\n\n\n\u4e0echar_length\u5b8c\u5168\u4e00\u6837\uff0c\u8fd4\u56de\u5b57\u7b26\u4e32 str \u7684\u5b57\u7b26\u957f\u5ea6\uff0c\u4ee5\u5b57\u7b26\u4e2a\u6570\u4e3a\u5355\u4f4d\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>CONCAT<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de\u7ed3\u679c\u4e3a\u8fde\u63a5\u53c2\u6570\u4ea7\u751f\u7684\u5b57\u7b26\u4e32\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>current_date<\/a><\/span><\/h2>\n\n\n\n\u5f53\u524d\u65e5\u671f\uff0c\u4e0d\u5305\u542b\u65f6\u95f4\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>current_datetime<\/a><\/span><\/h2>\n\n\n\n\u5f53\u524d\u65e5\u671f\u65f6\u95f4\uff0c\u5305\u542b\u6beb\u79d2\uff0c\u5fae\u79d2\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>current_time<\/a><\/span><\/h2>\n\n\n\n\u5f53\u524d\u65f6\u95f4<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>current_timestamp<\/a><\/span><\/h2>\n\n\n\n\u5f53\u524d\u65f6\u95f4\u6233\uff0c\u65e5\u671f\u548c\u65f6\u95f4\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>CONV<\/a><\/span><\/h2>\n\n\n\n\u4e0d\u540c\u6570\u5b57\u8fdb\u5236\u95f4\u7684\u8f6c\u6362<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>DAYOFWEEK<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de date (1 = \u5468\u65e5, 2 = \u5468\u4e00, \u2026, 7 = \u5468\u516d)\u5bf9\u5e94\u7684\u5de5\u4f5c\u65e5\u7d22\u5f15<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>ELT<\/a><\/span><\/h2>\n\n\n\n<\/p>\n\n\n\n<\/span>FIELD<\/a><\/span><\/h2>\n\n\n\n\u67e5\u627e\u5b57\u7b26\u4e32\u6240\u5728\u7684\u4f4d\u7f6e\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>FIND_IN_SET(str,strlist)<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de\u5b57\u7b26\u4e32 str \u5728 strlist \u4e2d\u5bf9\u5e94\u7684\u4f4d\u7f6e<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>HEX(N_or_S)<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de\u53c2\u6570\u5bf9\u5e94\u7684\u5341\u516d\u8fdb\u5236\u503c<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>IF(expr1,expr2,expr3)<\/a><\/span><\/h2>\n\n\n\n\u5982\u679c expr1 \u4e3a TRUE \u5219 IF()\u7684\u8fd4\u56de\u503c\u4e3a expr2\uff0c\u5982\u679c expr1 \u53d6\u503c\u4e3a FALSE\u30010 \u6216NULL\uff0c\u5219\u8fd4\u56de\u503c\u4e3a expr3\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>IFNULL(expr1,expr2)<\/a><\/span><\/h2>\n\n\n\n\u5982\u679c expr1 \u4e0d\u4e3a NULL\uff0c\u5219 IFNULL()\u7684\u8fd4\u56de\u503c\u4e3a expr1\uff0c\u5426\u5219\u5176\u8fd4\u56de\u503c\u4e3a expr2\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>insert(str,pos,len,newstr)<\/a><\/span><\/h2>\n\n\n\n\u5c06str\u5b57\u7b26\u4e32\uff0c\u4ece\u6307\u5b9a\u4f4d\u7f6epos\u5f00\u59cb\uff0c\u6307\u5b9a\u957f\u5ea6len\u7684\u5b57\u7b26\uff0c\u66ff\u6362\u6210newstr\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>INSTR(str,substr,start_position,nth_appearance)<\/a><\/span><\/h2>\n\n\n\n\u67e5\u627esubstr\u5728str\u4e2d\u51fa\u73b0\u7684\u5b57\u7b26\u4f4d\u7f6e\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>LENGTH(str)<\/a><\/span><\/h2>\n\n\n\n\u8fd4\u56de\u5b57\u7b26\u4e32 str \u7684\u957f\u5ea6\uff0c\u4ee5\u5b57\u8282\u8fdb\u884c\u8ba1\u7b97\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>LTRIM(str)<\/a><\/span><\/h2>\n\n\n\n\u79fb\u9664\u5b57\u7b26\u4e32\u5de6\u4fa7\u5f00\u5934\u7684\u5168\u90e8\u7a7a\u683c<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>MAKEDATE<\/a><\/span><\/h2>\n\n\n\n\u7ed9\u51fa\u5e74\u4efd\u503c year \u548c\u4e00\u5e74\u4e2d\u7684\u5929\u6570\u503c dayofyear\uff0c\u8fd4\u56de\u65e5\u671f\u503c\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>MICROSECOND(expr)<\/a><\/span><\/h2>\n\n\n\n\u4ee5\u6570\u5b57\u7684\u5f62\u5f0f\u8fd4\u56de time \u6216\u8005 datetime \u8868\u8fbe\u5f0f expr \u4e2d\u7684\u5fae\u79d2\u503c<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>MID(str,pos,len)<\/a><\/span><\/h2>\n\n\n\n\u622a\u53d6\u6307\u5b9a\u4f4d\u7f6e\u5f00\u59cb\u7684\u6307\u5b9a\u957f\u7684\u7684\u5b57\u7b26\u4e32,\u4e8eSubstring(str,pos,len)\u5b8c\u5168\u4e00\u6837\u3002<\/p>\n\n\n\n<\/span>NOW()<\/a><\/span><\/h2>\n\n\n\n\u5f53\u524d\u65e5\u671f\u65f6\u95f4<\/p>\n\n\n\n<\/span>NULLIF(expr1,expr2)<\/a><\/span><\/h2>\n\n\n\n\u5982\u679c expr1 = expr2 \u6210\u7acb\uff0c\u8fd4\u56de\u503c\u4e3a NULL\uff0c\u5426\u5219\u8fd4\u56de\u503c\u4e3a expr1\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>REGEXP_LIKE(source_char, pattern [, match_parameter])<\/a><\/span><\/h2>\n\n\n\n\u6a21\u7cca\u5339\u914d\u6307\u5b9a\u7684\u5b57\u7b26\u4e32\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>regexp_instr()<\/a><\/span><\/h2>\n\n\n\n\u6b63\u5219\u83b7\u5f97\u5339\u914d\u5b57\u7b26\u4e32\u7684\u4f4d\u7f6e<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>regexp_replace()<\/a><\/span><\/h2>\n\n\n\n\u6b63\u5219\u66ff\u6362\u51fd\u6570<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>replace(str,from_str,to_str)<\/a><\/span><\/h2>\n\n\n\n\u5c06 str \u4e2d\u6240\u6709\u51fa\u73b0\u7684 from_str \u66ff\u6362\u4e3a to_str \u540e\u7684\u5b57\u7b26\u4e32<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>RTRIM(str)<\/a><\/span><\/h2>\n\n\n\n\u79fb\u9664\u5b57\u7b26\u4e32\u53f3\u4fa7\u7ed3\u5c3e\u7684\u5168\u90e8\u7a7a\u683c<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>SUBSTR<\/a><\/span><\/h2>\n\n\n\n\u622a\u53d6\u6307\u5b9a\u4f4d\u7f6e\u5f00\u59cb\u7684\u6307\u5b9a\u957f\u7684\u7684\u5b57\u7b26\u4e32\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>SUBSTRING<\/a><\/span><\/h2>\n\n\n\nSUBSTR\u7684\u5b8c\u6574\u540d\u5b57\u3002\u622a\u53d6\u6307\u5b9a\u4f4d\u7f6e\u5f00\u59cb\u7684\u6307\u5b9a\u957f\u7684\u7684\u5b57\u7b26\u4e32\u3002<\/p>\n\n\n\n<\/p>\n\n\n\n<\/span>
\u8fd4\u56de\u5b57\u7b26\u4e32 str \u9996\u5b57\u7b26\u7684 ASCII \u7801\u503c\u3002<\/p>\n\n\n\n
<\/p>\n\n\n\n
\u8fd4\u56de N \u7684\u4e8c\u8fdb\u5236\u5f62\u5f0f<\/p>\n\n\n\n
\u8fd4\u56de\u5b57\u7b26\u4e32 str \u7684\u6bd4\u7279\u957f\u5ea6\uff0c\u4ee5\u6bd4\u7279\u8fdb\u884c\u8ba1\u7b97\u3002<\/p>\n\n\n\n
\u8fd4\u56de\u76f8\u5e94\u4ee3\u8868\u7684 ASCII \u7801\u503c\u5bf9\u5e94\u7684\u5b57\u7b26\u7ec4\u6210\u7684\u5b57\u7b26\u4e32\u3002<\/p>\n\n\n\n
\u8fd4\u56de\u5b57\u7b26\u4e32 str \u7684\u5b57\u7b26\u957f\u5ea6\uff0c\u4ee5\u5b57\u7b26\u4e2a\u6570\u4e3a\u5355\u4f4d\u3002<\/p>\n\n\n\n
\u4e0echar_length\u5b8c\u5168\u4e00\u6837\uff0c\u8fd4\u56de\u5b57\u7b26\u4e32 str \u7684\u5b57\u7b26\u957f\u5ea6\uff0c\u4ee5\u5b57\u7b26\u4e2a\u6570\u4e3a\u5355\u4f4d\u3002<\/p>\n\n\n\n
\u8fd4\u56de\u7ed3\u679c\u4e3a\u8fde\u63a5\u53c2\u6570\u4ea7\u751f\u7684\u5b57\u7b26\u4e32\u3002<\/p>\n\n\n\n
\u5f53\u524d\u65e5\u671f\uff0c\u4e0d\u5305\u542b\u65f6\u95f4\u3002<\/p>\n\n\n\n
\u5f53\u524d\u65e5\u671f\u65f6\u95f4\uff0c\u5305\u542b\u6beb\u79d2\uff0c\u5fae\u79d2\u3002<\/p>\n\n\n\n
\u5f53\u524d\u65f6\u95f4<\/p>\n\n\n\n
\u5f53\u524d\u65f6\u95f4\u6233\uff0c\u65e5\u671f\u548c\u65f6\u95f4\u3002<\/p>\n\n\n\n
\u4e0d\u540c\u6570\u5b57\u8fdb\u5236\u95f4\u7684\u8f6c\u6362<\/p>\n\n\n\n
\u8fd4\u56de date (1 = \u5468\u65e5, 2 = \u5468\u4e00, \u2026, 7 = \u5468\u516d)\u5bf9\u5e94\u7684\u5de5\u4f5c\u65e5\u7d22\u5f15<\/p>\n\n\n\n
\u67e5\u627e\u5b57\u7b26\u4e32\u6240\u5728\u7684\u4f4d\u7f6e\u3002<\/p>\n\n\n\n
\u8fd4\u56de\u5b57\u7b26\u4e32 str \u5728 strlist \u4e2d\u5bf9\u5e94\u7684\u4f4d\u7f6e<\/p>\n\n\n\n
\u8fd4\u56de\u53c2\u6570\u5bf9\u5e94\u7684\u5341\u516d\u8fdb\u5236\u503c<\/p>\n\n\n\n
\u5982\u679c expr1 \u4e3a TRUE \u5219 IF()\u7684\u8fd4\u56de\u503c\u4e3a expr2\uff0c\u5982\u679c expr1 \u53d6\u503c\u4e3a FALSE\u30010 \u6216NULL\uff0c\u5219\u8fd4\u56de\u503c\u4e3a expr3\u3002<\/p>\n\n\n\n
\u5982\u679c expr1 \u4e0d\u4e3a NULL\uff0c\u5219 IFNULL()\u7684\u8fd4\u56de\u503c\u4e3a expr1\uff0c\u5426\u5219\u5176\u8fd4\u56de\u503c\u4e3a expr2\u3002<\/p>\n\n\n\n
\u5c06str\u5b57\u7b26\u4e32\uff0c\u4ece\u6307\u5b9a\u4f4d\u7f6epos\u5f00\u59cb\uff0c\u6307\u5b9a\u957f\u5ea6len\u7684\u5b57\u7b26\uff0c\u66ff\u6362\u6210newstr\u3002<\/p>\n\n\n\n
\u67e5\u627esubstr\u5728str\u4e2d\u51fa\u73b0\u7684\u5b57\u7b26\u4f4d\u7f6e\u3002<\/p>\n\n\n\n
\u8fd4\u56de\u5b57\u7b26\u4e32 str \u7684\u957f\u5ea6\uff0c\u4ee5\u5b57\u8282\u8fdb\u884c\u8ba1\u7b97\u3002<\/p>\n\n\n\n
\u79fb\u9664\u5b57\u7b26\u4e32\u5de6\u4fa7\u5f00\u5934\u7684\u5168\u90e8\u7a7a\u683c<\/p>\n\n\n\n
\u7ed9\u51fa\u5e74\u4efd\u503c year \u548c\u4e00\u5e74\u4e2d\u7684\u5929\u6570\u503c dayofyear\uff0c\u8fd4\u56de\u65e5\u671f\u503c\u3002<\/p>\n\n\n\n
\u4ee5\u6570\u5b57\u7684\u5f62\u5f0f\u8fd4\u56de time \u6216\u8005 datetime \u8868\u8fbe\u5f0f expr \u4e2d\u7684\u5fae\u79d2\u503c<\/p>\n\n\n\n
\u622a\u53d6\u6307\u5b9a\u4f4d\u7f6e\u5f00\u59cb\u7684\u6307\u5b9a\u957f\u7684\u7684\u5b57\u7b26\u4e32,\u4e8eSubstring(str,pos,len)\u5b8c\u5168\u4e00\u6837\u3002<\/p>\n\n\n\n
\u5f53\u524d\u65e5\u671f\u65f6\u95f4<\/p>\n\n\n\n
\u5982\u679c expr1 = expr2 \u6210\u7acb\uff0c\u8fd4\u56de\u503c\u4e3a NULL\uff0c\u5426\u5219\u8fd4\u56de\u503c\u4e3a expr1\u3002<\/p>\n\n\n\n
\u6a21\u7cca\u5339\u914d\u6307\u5b9a\u7684\u5b57\u7b26\u4e32\u3002<\/p>\n\n\n\n
\u6b63\u5219\u83b7\u5f97\u5339\u914d\u5b57\u7b26\u4e32\u7684\u4f4d\u7f6e<\/p>\n\n\n\n
\u6b63\u5219\u66ff\u6362\u51fd\u6570<\/p>\n\n\n\n
\u5c06 str \u4e2d\u6240\u6709\u51fa\u73b0\u7684 from_str \u66ff\u6362\u4e3a to_str \u540e\u7684\u5b57\u7b26\u4e32<\/p>\n\n\n\n
\u79fb\u9664\u5b57\u7b26\u4e32\u53f3\u4fa7\u7ed3\u5c3e\u7684\u5168\u90e8\u7a7a\u683c<\/p>\n\n\n\n
\u622a\u53d6\u6307\u5b9a\u4f4d\u7f6e\u5f00\u59cb\u7684\u6307\u5b9a\u957f\u7684\u7684\u5b57\u7b26\u4e32\u3002<\/p>\n\n\n\n
SUBSTR\u7684\u5b8c\u6574\u540d\u5b57\u3002\u622a\u53d6\u6307\u5b9a\u4f4d\u7f6e\u5f00\u59cb\u7684\u6307\u5b9a\u957f\u7684\u7684\u5b57\u7b26\u4e32\u3002<\/p>\n\n\n\n