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,

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值