mysql 查找替换

发现mysql数据库某字段里的字符串里写入时少了个引号，用mysql的查找替换

• 语法

  UPDATE table_name SET field=REPLACE(field, pattern_str, replace_str);

• 实例

    UPDATE tysp_video_info SET SHARE_LINK = REPLACE(SHARE_LINK, 'auto=0', 'auto=0"');
  

• http://www.cnblogs.com/luoine/archive/2011/03/31/2001084.html

• http://segmentfault.com/q/1010000000147285