Depends on the DB In MSSQL you can go
UPDATE Table SET Column = REPLACE(Column,'images/','http://www.foo.com.au/images/') That should update the values to include the full path Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brad Apps Sent: Friday, September 05, 2003 1:34 PM To: CFAussie Mailing List Subject: [cfaussie] Replacing a string and inserting into a database. Hey, I should be able to do this but I have a mental block. Here's the problem: I have web site content stored in a DB which is hooked to a CMS which I have developed. I need to replace all occurances of 'images/' with 'http://www.foo.com.au/images/'. What would be the best way to do this? Something like the Replace and/or find functions. But it needs to fine all occurances replace them and then update the DB. Any ideas? Thanks. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
