mysql replace \\r\\n失败，php继续
str_replace(array("\r\n","\n"),'|',$content);
需要注意的是，\r\n 和\n需要使用双引号包裹，否则不能正确解析
str_replace(array("\n","\r")??, array('',''), $content)
?
?
http://lists.mysql.com/mysql/205840
?
View as plain text ?
I always go with REPLACE(REPLACE(STRING, '\n', ''), '\r', ''), since depending on where your data came from there may be one or the other, or both. Although if there is a shorthand/more efficient way I'd love to hear it.Lucas.CTR.Heuman@stripped wrote:> Ok.. I found the problem.. I needed to add a \r.. but now that opens up > the question can I have a Multi replace search in replace?> > > Example can I do something like this in MySQL> > REPLACE (STRING,'\r' or '\n',' ')> > > REPLACE(DESCRIPTION,'\r\n',' ')> > Wishing you the best you know you deserve,
