以varchar性字段值中某一字符为条件查询及修改sql语句
SQL语句查找出varchar字段中以“URL查询字符串”格式存放的数据
例如：以字段vod_pic字段值中有‘im.qvodzy.me’字符为条件查询
SELECT * FROM pp_vod WHERE INSTR(`vod_pic`,CONCAT('im.reyu123.com','/'))>0
SELECT * FROM pp_vod WHERE INSTR(`vod_pic`,CONCAT('im.reyu123.com','/'))>0
SELECT * FROM pp_vod WHERE INSTR(`vod_pic`,CONCAT('2011-12','/'))>0
update pp_vod set vod_pic = replace(vod_pic,'kuaibo.com','gvod.net')
update pp_vod set vod_pic='' where INSTR(`vod_pic`,CONCAT('2011-12','/'))>0
