0

MySQL 怎样批量替换字符串?

edith created at7 years ago view count: 2405

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

report
回复
0

使用REPLACE

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

Recent search keywords