spacenews表里面的message字段含有 “大图”这两个字。
怎么把这俩字去掉。itemid从1000-2000的表都要改。select replace(message,'大图','') from 'spacenews' where itemid=1000 to 2000; 是这样吗????
怎么把这俩字去掉。itemid从1000-2000的表都要改。select replace(message,'大图','') from 'spacenews' where itemid=1000 to 2000; 是这样吗????
update spacenews set message = replace(message,'大图','') where itemid > 1000 and itemid < 2000;