去除两边空格
SELECT TRIM(' 123 ') from xxx 结果123
去除左边空格
SELECT LTRIM(' 123') from xxx 结果123
去除右边空格
SELECT RTRIM('123 ') from xxx 结果123
去除两边指定字符
SELECT TRIM(BOTH '000' FROM '000123000'); 结果123
去除左边指定字符
SELECT TRIM(LEADING '000' FROM '000123000'); 结果123000
去除右边指定字符
SELECT TRIM(TRAILING '000' FROM '000123000'); 结果000123