Re: Replacing spaces with commas
| From: | W Luke | Date: | Sun, 17 Apr 2005 13:59:24 +0000 |
| Subject: | Re: Replacing spaces with commas | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-213236@lists.php.net to get a copy of this message | ||
On 4/17/05, trlists@clayst.com <trlists@clayst.com> wrote:
> > 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?
>
> Well I have not used this function, but it looks like it would do what
> you want (this is from MySQL):
>
> REPLACE(str,from_str,to_str)
Now why didn't I think of that? Easy as pie - thanks Tom, working
like a charm...
--
Will The Corridor of Uncertainty http://www.cricket.mailliw.com/
- Sanity is a madness put to good use -