HOHO采来的数据还是需要改改的
比如删除不需要的HTML标签
收集到了批量替换语句

UPDATE 表名 SET
指定字段 = replace(指定字段, ’要替换的字符串’, ’想要的字符串’) 
WHERE 条件;

今天用到的删除空格的

UPDATE `qlj_joke` SET content = replace(content,' ','') ;

mysql

This entry was posted on 星期四, 四月 1st, 2010 at 8:23 下午 and is filed under mysql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.