mysql表字段中的字符串替换

将video表中id大于7的记录中的title字段中的字符串3.1替换为4.1

update video set title = replace(title,'3.1','4.1') where id >7

 

 

 

 

update sc_resource2 set url = replace(url,'http://xx.xx.xx.xx/localResource/public','http://xx.xx.xx.xx:81')

点赞
  1. Pokerdomded说道:

    Warning: Undefined variable $uapic in /www/wwwroot/www.murongx.cn/wp-content/themes/kratos-pjax-master/inc/ua.php on line 424
    Google Chrome Windows 10
    https://t.me/officials_pokerdom/3511
  2. HighRollerMage说道:

    Warning: Undefined variable $uapic in /www/wwwroot/www.murongx.cn/wp-content/themes/kratos-pjax-master/inc/ua.php on line 424
    Google Chrome Windows 10
    https://t.me/s/BeEfCasInO_oFfICIaLs

发表回复

电子邮件地址不会被公开。必填项已用 * 标注