Table modification

I have a named table which contains a field URL. I have at least 200 links and they begins all with: http://mmarea2.free.fr/files/namefiles, http://mmarea3.free.fr/files/namefiles, and http://mmarea4.free.fr/files/namefiles. They all are down. I would like to know how to change these address towards another address (ex: http://0.0.0.127/files/namefiles without doing it manually. I hope that you understood.

UPDATE table SET url = (REPLACE(url,"mmarea2.free.fr","0.0.0.127")) WHERE url LIKE "%mmarea2.free.fr%"

That should do the first one, and then you can just change it for the other two.

Disclaimer: I have not tested this! Back up your table before doing anything.

Matt Wade
codewalkers.com