mysql查找替换文本和常用命令

UPDATE mytable SET mycolumn = REPLACE(mycolumn, 'oldtext', 'newtext');
常用语句对照：
1.查询数据 SELECT * FROM {pre}vod 查询所有数据
SELECT * FROM {pre}vod WHERE vod_id=1000 查询指定ID数据
2.删除数据 DELETE FROM {pre}vod 删除所有数据
DELETE FROM {pre}vod WHERE vod_id=1000 删除指定的第几条数据
DELETE FROM {pre}vod WHERE vod_actor LIKE '%张思%' vod_actor"张思"的数据
3.修改数据 UPDATE {pre}vod SET vod_hits=1 将所有vod_hits字段里的值修改成"1"
UPDATE {pre}vod SET vod_hits=1 WHERE vod_id=1000 指定的第几条数据把vod_hits字段里的值修改成"1"
4.替换图片地址 UPDATE {pre}vod SET vod_pic=REPLACE(vod_pic, '原始字符串', '替换成其他字符串')
5.清空数据ID重新从1开始 TRUNCATE {pre}vod
UPDATE mac_vod  SET vod_pic='' WHERE vod_pic LIKE '%1111%' 模糊查找替换整个字段内容
uPDATE mac_vod SET vod_play_from = CONCAT(vod_play_from, '$$$%tpm3u8') WHERE vod_play_from LIKE '%tpm3u8$$$%%'; 查找修改字符到尾部
UPDATE mac_vod SET vod_hits=1000 点击量
UPDATE mac_vod SET vod_hits_day=1000 日点击
UPDATE mac_vod SET vod_hits_week=1000 周点击
 UPDATE mac_vod SET vod_hits_month=1000 月点击