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

以上是编程学习网小编为您介绍的“mysql如何截取/替换字符串”的全面内容，想了解更多关于 mysql 内容，请继续关注编程基础学习网。