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,
欢迎大家阅读《mysql replace //r//n失败,php持续》,跪求各位点评,by 搞代码