1.修改字段里的所有含有指定字符串的文字

UPDATE eb_store_box SET image = replace(image, 'https://xhpit.com', 'https://www.baidu.com');

2.修改字段值为随机数(200到900)

UPDATE eb_store_product SET ficti = FLOOR(200 + (RAND() * 700)) WHERE is_del = 0;