Re: REPLACE fails to find newlines

2002-12-04 Thread Kenneth Porter
--On Tuesday, December 03, 2002 12:14 PM -0500 "Keith C. Ivey" <[EMAIL PROTECTED]> wrote: > My first guess is that you have CRLF where you think you've got just > LF. Have you tried the query with '\r\n' in place of '\n'? That was it. I guess the data must have been imported from source that wa

REPLACE fails to find newlines

2002-12-03 Thread Kenneth Porter
Using Red Hat 8.0, mysql-3.23.52-3, and phpMyAdmin-2.3.3. I'm importing a bunch of old posts from one bboard system (Ezboards) into a new one (Burning Board), and the process left a bunch of HTML "" on the end of each line that is now unwanted. (I'm getting double-spacing.) I figured this SQL sho