0

MySQL 怎样批量替换字符串?

edith created at6 years ago view count: 2397

数据库里面保存的图片地址是http://,现在要替换为https://开始的,怎样替换?

report
回复
0

使用REPLACE

UPDATE table_name
SET `image` = REPLACE(src, 'http:', 'https:')
6 years ago 回复