UPDATE TitlesSET titleid = REPLACE(titleid, LEFT(titleid, 3), "ABB")WHERE type = 'business'
一楼的完全正确!真厉害!!!