Mysql REPLACE LOCATE 应用 



SELECT * FROM `ims_superdesk_shop_goods` WHERE merchid !=8 and LOCATE('http://www.avic-s.com/memberShop-admin/',thumb) >0


正在显示第 100 - 124 行 (共 537 行, 查询花费 0.0029 秒。)



UPDATE ims_superdesk_shop_goods SET thumb=REPLACE(thumb, 'http://www.avic-s.com/memberShop-admin//', 'https://mall.avic-s.com/') where merchid !=8 and LOCATE('http://www.avic-s.com/memberShop-admin/',thumb) >0;

UPDATE ims_superdesk_shop_goods SET thumb=REPLACE(thumb, 'http://www.avic-s.com/memberShop-admin/', 'https://mall.avic-s.com/') where merchid !=8 and LOCATE('http://www.avic-s.com/memberShop-admin/',thumb) >0;


http://www.avic-s.com/memberShop-admin/images/pic/1488876678591.jpg



http://www.avic-s.com/memberShop-admin//images/pic/1504873414064.jpg


UPDATE ims_superdesk_shop_goods set updatetime = UNIX_TIMESTAMP() WHERE merchid !=8 and LOCATE('https://mall.avic-s.com/',thumb) >0;

未标明原创文章均为采集，版权归作者所有，转载无需和我联系，请注明原出处，南摩阿彌陀佛，知识，不只知道，要得到

请先后发表评论
  • 最新评论
  • 总共0条评论