浏览文章
文章信息
mysql替换数据库中的css，删除|替换宽高
406
mysql 8.0.12
UPDATE `oc_product_description`
SET `description` = REGEXP_REPLACE ( `description`, ' (width|height):[^;"]*([;"])', '$2' )
WHERE
product_id = 77
AND language_id = 1mysql7
UPDATE `oc_product_description`
SET REPLACE ( SUBSTRING_INDEX( SUBSTRING_INDEX( `description`, 'width:', - 1 ), 'height:', - 1 ), ';', '' )
WHERE
product_id = 77
AND language_id =1
