SQL学习3.5-Replace()函数

1. replace("10,A,B",",",""))

• "10,A,B"代表了要操作的字符串
• ","代表要被替换的字符串内容是，
• " "代表将","替换成""(null)

2.length(replace("10,A,B",",",""))

• 表示的是括号内字符串的长度