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,