MySQL: Remove Carriage Returns from Addresses June 23rd, 2014

SELECT * FROM local_page WHERE page_hotel_address REGEXP "\r\n";