Jump to content

Updating several columns in several tables


aeris130

Recommended Posts

I would like to check every column in every table in my entire MySQL-database. Whenever the string of text "http://www.myurl.com/web" is located inside a column (even though there may be other content there as well), I'd like to replace it (i.e update the column) with "http://www.myurl.com", and leave the rest of said columns text/data as it is.

 

Can this be done using a single SQL-syntax?

Would it be possible to specify a single column in a single table, and only edit/update the string "http://www.myurl.com/web" if it's present (without having to update the entire column, thus leaving the remaining content as-is)?

 

Or do I have to redefine the entire content in the column through some sort of script?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.