On 4/17/05, trlists@xxxxxxxxxx <trlists@xxxxxxxxxx> 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 - -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
