参考博文为(https://blog.csdn.net/wzx19840423/article/details/77507772)
instr()函数参考博文为:https://www.cnblogs.com/dshore123/p/7813230.html
left(),right()函数参考博文为:https://blog.csdn.net/qq_27495157/article/details/77995972
substring()函数参考博文为:https://blog.csdn.net/hehuihh/article/details/79033047
具体语法为:
update asking set doctor =right(doctor, INSTR(doctor, ‘院’) - 2) where doctor like ‘%院%’;
解析为:
asking为表名;
right()函数是留下‘%院%’字符串中‘院’之后的字符串;
instruction()函数是定位函数,将doctor字段中的字符串定位到‘院’这个位置;
-2代表是该字符串从‘院’这个字符之后的两个字符处;