How can I check if an SQL result contains a newline character?

SELECT * FROM mytable WHERE mycolumn REGEXP "\n";

select cc.columnname,right(cc.columnname,1),ASCII(right(cc.columnname,1)) ,cc.*
from table_name cc where 
ASCII(right(cc.columnname,1)) = 13

here

• cc.columnname => Column name is column where you want to fine new line or Carriage return.
• right(cc.columnname,1) => this will show only one char what is there at the end. usually it display only blank
• ASCII(right(cc.columnname,1)) => here we get Acii value of that not printable value.

by seeing this ascii value we can conclude which item it is. Example , if this acsci value is 13 then Carriage return , if it is 10 then NEw line we have to use this to filter that record

• cc.* => this gives all the values from the table ( display purpose)
• where ASCII(right(cc.columnname,1)) = 13 => here i found all the values are 13 asci value so filtering ascii value 13

it is working for me .

For any fellow Redshift users who end up here:

select * from your_table where your_column ~ '[\r\n]+'