Replacing spaces with commas
| From: | W Luke | Date: | Sun, 17 Apr 2005 12:34:45 +0000 |
| Subject: | Replacing spaces with commas | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-213234@lists.php.net to get a copy of this message | ||
Hi,
I have about 200 records in a table, and I need to update 2 of the
fields. The first is easy, but the second contains a list of keywords
all separated by spaces; I need to replace the spaces with commas. Is
this something I can do with some clever SQL, or shall I just do it in
PHP?
Any ideas appreciated
Cheers,
--
Will The Corridor of Uncertainty http://www.cricket.mailliw.com/
- Sanity is a madness put to good use -