List:General Discussion« Previous MessageNext Message »
From:gerald_clark Date:December 3 2002 5:33pm
Subject:Re: REPLACE fails to find newlines
View as plain text  
Since '\n' is ignored in HTML, that is not your problem.
The answer is probably in your PHP setup or code.

Kenneth Porter wrote:

>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 "<br>" on the
>end of each line that is now unwanted. (I'm getting double-spacing.)
>
>I figured this SQL should remove the extraneous breaks:
>
>UPDATE `bb1_posts` SET message = REPLACE(message,'<br>\n','\n') WHERE 1;
>
>message is a text field usually with multiple lines in a record.
>
>Alas, this doesn't seem to find the records that appear in the phpMyAdmin
>browser with this characteristic, and I get zero records updated. What
>could I be doing wrong?
>
>---------------------------------------------------------------------
>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 <mysql-thread126411@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>  
>


Thread
REPLACE fails to find newlinesKenneth Porter3 Dec
  • Re: REPLACE fails to find newlinesKeith C. Ivey3 Dec
    • Re: REPLACE fails to find newlinesKenneth Porter4 Dec
  • Re: REPLACE fails to find newlinesgerald_clark3 Dec