UPDATE mytable SET mycolumn = REPLACE(mycolumn, 'oldtext', 'newtext'); 常用语句对照： 1.查询数据 SELECT * FROM {pre}vod 查询所有数据 SELECT * FROM {pre}vod WHERE vod_id=1000 查询指...