MySQL常用的文本处理函数

select LENGTH('asdf');        // 字符串长度
select LTRIM(' as df ');        // 去掉左边空格
select RTRIM(' as df ');        // 去掉右边空格
select TRIM(' as df ');        // 只能去掉字符串左右两边的空格
select LOWER('ASdf');        // 转换为小写
select UPPER('ASdf');        // 转换为大写

LEFT()和RIGHT()函数：从左或右截取n个字符。

SUBSTR()和SUBSTRING()函数，字符串截取函数，从第m个字符截取n个。

select LEFT('asdf',n);
select RIGHT('asdf',n);
select SUBSTR('asdf' from m);
select SUBSTR('asdf' from m for n);
select SUBSTR('asdf',m);
select SUBSTR('asdf',m,n);
select SUBSTRING('asdf' from m);
select SUBSTRING('asdf' from m for n);
select SUBSTRING('asdf',m);
select SUBSTRING('asdf',m,n);

SOUNDEX()函数，模糊匹配发音相似的字符串数据。
select SOUNDEX('hello'),SOUNDEX('Hallo');
select ct.cust_name, ct.cust_contact from customers ct where SOUNDEX(ct.cust_contact) = SOUNDEX('Michael Green');