原文:http://blog.csdn.net/symgdwyh/article/details/8084745
实例:
1,将换行符替换为0字节的字符‘’
UPDATE table_name set field_name=REPLACE(REPLACE(field_name,char(10),'<br>'),char(13),'');
2,将换行符替换为‘000’
UPDATE table_name set field_name=REPLACE(REPLACE(field_name,char(10),'<br>'),char(13),'000');