mysql如何截取/替换字符串

mysql如何截取或替换字符串，下面编程教程网小编给大家详细介绍一下具体使用方法！

从左开始截取字符串

select left('webSiteBbuildingTutorial', 5) as result from dual;

//输出结果：webSi

从右开始截取字符串

select right('webSiteBbuildingTutorial',5) as result from dual;

//输出结果：orial

替换相关字符

select replace ('webSiteBbuildingTutorial','i','TT') as result from dual;

//把所有i替换成TT