sql语句 查询 并 修改 字段值 代码

这个代码批量修改的

比如查询 数据库  A 表 里面B 字段值 有没有这个值 然后修改 c字段里面的值

比如

B字段 里面有的 是.zip 值 有的是.txt值  我需要查询 B字段里面所以.txt 的值  然后修改C字段里面的值。

update pre_forum_attachment_1 set price = replace(price,'1','30') where filename like '%.txt';

意思

查询 pre_forum_attachment_1表里面filename字段 里面有没有 .txt 的值 有的话 修改所有price 字段里面 1值为30

update pre_forum_attachment_1 set price = 50 where filename like '%.txt';

意思

查询 pre_forum_attachment_1表里面filename字段 里面有没有 .txt 的值 有的话 修改所有price 字段值为30update pre_forum_attachment_0 set price = 30 where filename like '%.txt';

update pre_forum_attachment_0 set price = 30 where filename like '%.zip';

update pre_forum_attachment_0 set price = 30 where filename like '%.rar';

update pre_forum_attachment_1 set price = 30 where filename like '%.txt';

update pre_forum_attachment_1 set price = 30 where filename like '%.zip';

update pre_forum_attachment_1 set price = 30 where filename like '%.rar';

update pre_forum_attachment_2 set price = 30 where filename like '%.txt';

update pre_forum_attachment_2 set price = 30 where filename like '%.zip';

update pre_forum_attachment_2 set price = 30 where filename like '%.rar';

update pre_forum_attachment_3 set price = 30 where filename like '%.txt';

update pre_forum_attachment_3 set price = 30 where filename like '%.zip';

update pre_forum_attachment_3 set price = 30 where filename like '%.rar';

update pre_forum_attachment_4 set price = 30 where filename like '%.txt';

update pre_forum_attachment_4 set price = 30 where filename like '%.zip';

update pre_forum_attachment_4 set price = 30 where filename like '%.rar';

update pre_forum_attachment_5 set price = 30 where filename like '%.txt';

update pre_forum_attachment_5 set price = 30 where filename like '%.zip';

update pre_forum_attachment_5 set price = 30 where filename like '%.rar';

update pre_forum_attachment_6 set price = 30 where filename like '%.txt';

update pre_forum_attachment_6 set price = 30 where filename like '%.zip';

update pre_forum_attachment_6 set price = 30 where filename like '%.rar';

update pre_forum_attachment_7 set price = 30 where filename like '%.txt';

update pre_forum_attachment_7 set price = 30 where filename like '%.zip';

update pre_forum_attachment_7 set price = 30 where filename like '%.rar';

update pre_forum_attachment_8 set price = 30 where filename like '%.txt';

update pre_forum_attachment_8 set price = 30 where filename like '%.zip';

update pre_forum_attachment_8 set price = 30 where filename like '%.rar';

update pre_forum_attachment_9 set price = 30 where filename like '%.txt';

update pre_forum_attachment_9 set price = 30 where filename like '%.zip';

update pre_forum_attachment_9 set price = 30 where filename like '%.rar';