On 3 Dec 2002, at 6:29, Kenneth Porter wrote: > I figured this SQL should remove the extraneous breaks: > > UPDATE `bb1_posts` SET message = REPLACE(message,'<br>\n','\n') WHERE 1;
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'? -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
