How to show the original character like \n \t in mysql in a select statement

Question

when I run select statement from mysql database, characters like \n \t will be escaped. Is there a way to see these original characters in mysql?

What I want to see is something like "java.lang.Exception: Container released on a lost node\r\n\tat"

Don't you really mean the opposite? You're apparently getting the original character (a literal tabulator or a carriage return) and you want to replace if with a escape sequence. — Álvaro González
– Álvaro González, Commented Oct 22, 2018 at 11:22
I cannot reproduce it. Are you able to create a fiddle that exhibits the issue? — Álvaro González
– Álvaro González, Commented Oct 22, 2018 at 11:36
@SalmanA the issue is that when I run a sql query with select and where statement, I always find there is a mismatch. Sometimes it is due to "\r\n" vs "\n" and sometimes of encoding. However, for these differences, I could not tell from the output by eyes. — Bargitta
– Bargitta, Commented Oct 23, 2018 at 2:20

Mayank Porwal · Accepted Answer · 2018-10-22 11:04:31Z

0

Try this:

SELECT * FROM table 
WHERE column_name REGEXP "\n" 
OR column_name REGEXP "\t";

answered Oct 22, 2018 at 11:04

Mayank Porwal

34.2k9 gold badges46 silver badges66 bronze badges

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

1 Answer 1