Remove carriage returns in text column during MySQL query in PHP script

Question

I'm selecting a text column in a MySQL query for export to a csv file in a PHP script. It turns out the text column has carriage returns which is causing an issue with import on the other end.

How do I remove carriage returns while making the query and just present the text? Here is my current query:

SELECT marketing_remarks AS MarketingRemarks WHERE column = "blah"

Seems Google has the answer... google.co.uk/#q=php%20remove%20carriage%20return%20line%20feed - or is there a more specific problem you have? — ChrisW
– ChrisW, Commented Nov 7, 2013 at 11:52
The problem is not the select, the problem is that I need to remove the carriage returns in the result. — Rocco The Taco
– Rocco The Taco, Commented Nov 7, 2013 at 11:52
@ChrisW ...I don't see a SQL solution here, only PHP...I tried Google ;-) — Rocco The Taco
– Rocco The Taco, Commented Nov 7, 2013 at 11:54
Yes, I want to keep it in a single MySQL statement for ease of administration. Cleaner code, I only want PHP where I absolutely have to (creation of the export file etc.). If it concerns data processing, I figure it is better to keep that within the SQL and PHP for file operations. — Rocco The Taco
– Rocco The Taco, Commented Nov 7, 2013 at 11:59

user849001 · Accepted Answer · 2013-11-07 11:53:34Z

4

SELECT REPLACE(marketing_remarks, '\r', '') AS MarketingRemarks WHERE column = "blah"

Something like this?

answered Nov 7, 2013 at 11:53

user849001

Sign up to request clarification or add additional context in comments.

Comments

ChrisW · Accepted Answer · 2013-11-07 11:55:13Z

1

You can either do it in the query (as per Fredd's answer), or in the PHP:

str_replace("\r", '', $result); // remove carriage returns

there will be factors which will determine which is the best approach for you

answered Nov 7, 2013 at 11:55

ChrisW

5,0927 gold badges59 silver badges97 bronze badges

Collectives™ on Stack Overflow

Remove carriage returns in text column during MySQL query in PHP script

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related