On 17 Apr 2005 W Luke 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)
Returns the string str with all all occurrences of the string
from_str replaced by the string to_str
So for example:
REPLACE(field, ' ', ',');
In other words, how about a query like this:
UPDATE table SET field=REPLACE(field, ' ', ',');
I have not tried using a function in an UPDATE statement like this but
you can test it and see, I would expect it to work.
In PHP you can do the same thing -- load the data with the mysql_
functions, then:
$newval = str_replace(' ', ',', $oldval);
then use UPDATE to put $newval back into the database.
--
Tom
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
