mysql替换文本


替换回车换行符:

UPDATE tablename SET title = REPLACE(REPLACE(fieldname, '\r', ''), '\n', '');

 

Archives