mysql replace \\r\\n失败，php继续_PHP

您所在的位置：程序员俱乐部 > 编程开发 > PHP > mysql replace \\r\\n失败，php继续

mysql replace \\r\\n失败，php继续

2010/12/8 10:18:14 Robinson http://robinson.javaeye.com 我要评论(0)

摘要：str_replace(array("\r\n","\n"),'|',$content);需要注意的是，\r\n和\n需要使用双引号包裹，否则不能正确解析str_replace(array("\n","\r"),array('',''),$content)http://lists.mysql.com/mysql/205840ViewasplaintextIalwaysgowithREPLACE(REPLACE(STRING,'\n',''),'\r','')
标签：PHP 失败 SQL MySQL

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,