sql:trim 函数
trim 的作用
删除字符串左右两侧的空格
trim 的语法格式
TRIM(s)
例子(最多还是删除空格)
SELECT TRIM(LEADING 'x' FROM 'xxxbarxxx'); # barxxx
SELECT TRIM(BOTH 'x' FROM 'xxxbarxxx'); # bar
SELECT TRIM(TRAILING 'xyz' FROM 'barxxyz'); # barx
删除字符串左右两侧的空格
TRIM(s)
SELECT TRIM(LEADING 'x' FROM 'xxxbarxxx'); # barxxx
SELECT TRIM(BOTH 'x' FROM 'xxxbarxxx'); # bar
SELECT TRIM(TRAILING 'xyz' FROM 'barxxyz'); # barx