mysql trim() 去空

去除两边空格

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