Posted by W Luke on 04/17/05 16:59

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 -

[Back to original message]