替换REPLACE函数
REPLACE函数简介
语法:REPLACE(field,search,replace)
说明:field - 数据库表的字段名称
search - 需要替换的字符串
replace - 替换成的字符串
SQL:
update h_about_council set council_img_url = REPLACE(council_img_url , "http", "https");
REPLACE函数简介
语法:REPLACE(field,search,replace)
说明:field - 数据库表的字段名称
search - 需要替换的字符串
replace - 替换成的字符串
SQL:
update h_about_council set council_img_url = REPLACE(council_img_url , "http", "https");