Hello, is there a possibility to update a substring out of a database table field? I'd like to change the path of my URL field whereby the actual filename should stay the same. Can this be done with one query? Any help would be greatly appreciated, Michael
Hello, I found out the answer:
Update table SET url_field=REPLACE(url_field, 'www.olddomain.com', 'www.newdomain.com')
Cheers, Michael
