Q: How do I find line breaks in MySQL?

SELECT * FROM mytable WHERE mycolumn REGEXP "\r\n"; finds all records in mytable where mycolumn contains a \r\n sequence. At least in MySQL Workbench for Windows, when I used the " (double quote) from your answer, it was translated into a newline in my query and didn't work. I had to use ' (single quotes.)

Q: How do I insert a carriage return in MySQL?

-- Using both \r\n SELECT 'First line. \r\nSecond Line. ' AS 'New Line'; -- Using both \n SELECT 'First line.

Question 1

How do I find line breaks in MySQL?

Accepted Answer

SELECT * FROM mytable WHERE mycolumn REGEXP "
"; finds all records in mytable where mycolumn contains a 
 sequence. At least in MySQL Workbench for Windows, when I used the " (double quote) from your answer, it was translated into a newline in my query and didn't work. I had to use ' (single quotes.)

Question 2

How do I find carriage return and line feed in SQL?

Accepted Answer

Using SQL to remove a line feed or carriage return means using the CHAR function. A line feed is CHAR(10); a carriage return is CHAR(13).

Question 3

How do I insert a carriage return in MySQL?

Accepted Answer

-- Using both 
 SELECT 'First line. 
Second Line. ' AS 'New Line'; -- Using both 
 SELECT 'First line.

Question 4

What is CR LF in SQL?

Accepted Answer

SQL Carriage Return (CR): The Carriage Return moves the cursor to the beginning of the line. It does not move to the next line. Line feed (LF): The line feed moves the cursor to the next line. It does return to the beginning of the line.

Finding line break and carriage return (\r\n) in MySQL

Tags:

regex

select

mysql

line-breaks

carriage-return

Display name

People also ask

1 Answers

Tim Pietzcker

Recent Activity

Donate For Us