MySQL 去掉字符串前后或中间的某一字符串

--1、去掉字符串前后的空格 SELECT TRIM(' zhangsan '); +---------------------------+ | TRIM(' zhangsan ') | +---------------------------+ | zhangsan | +---------------------------+ --2、去掉左边指定的字符串 SELECT TRIM(LEADING 'x' FROM 'xxxzhangsanxxx'); +------------------------------------------------+ | TRIM(LEADING 'x' FROM 'xxxzhangsanxxx') | +------------------------------------------------+ | zhangsanxxx | +------------------------------------------------+ --3、去掉右边指定的字符串 SELECT TRIM(TRAILING 'x' FROM 'xxxzhangsanxxx'); +------------------------------------------------+ | TRIM(TRAILING 'x' FROM 'xxxzhangsanxxx') | +------------------------------------------------+ | xxxzhangsan | +------------------------------------------------+ --4、去掉前后指定的字符串 SELECT TRIM(BOTH 'x' FROM 'xxxzhangsanxxx'); +------------------------------------------------+ | TRIM(BOTH 'x' FROM 'xxxzhangsanxxx') | +------------------------------------------------+ | zhangsan | +------------------------------------------------+