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"

Answer 1

Try this:

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