UPDATE part of a column
| From: | Shaun | Date: | Tue, 23 Sep 2003 12:03:29 +0000 |
| Subject: | UPDATE part of a column | ||
| Groups: | php.db php.db | ||
| Request: | Send a blank email to php-db+get-30637@lists.php.net to get a copy of this message | ||
Hi,
I have a column in my table called address. When users add an address with a
textarea they sometimes press return for a new line and this seems to be
putting line breaks into the database, so I have 2 questions:
1. How can I clean the table, so for example changing:
Ashfield Business Centre<BR> The Idlewells Precinct<BR>
Sutton-in-Ashfield<BR>
to:
Ashfield Business Centre, The Idlewells Precinct, Sutton-in-Ashfield,
2, Is there a way to make sure the data is 'clean' before entering into the
table?
Thanks for your help