需求:更新url中最一个字符的'-1'改为'-5',前面的内容保持不变
url列的内容如下:http://h5game.ecs.cedarmg.com/a/captal/dispther.do?deviceid=b-01-1
SELECT * from qrmsgWHERE url LIKE '%1'
需求:更新url中最一个字符的'-1'改为'-5',前面的内容保持不变
url列的内容如下:http://h5game.ecs.cedarmg.com/a/captal/dispther.do?deviceid=b-01-1
SELECT * from qrmsgWHERE url LIKE '%1'