mysql replace //r//n失败，php持续

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,