I just wrote a little mysql snippet that will replace all instances of ‘domain1′ to ‘domain2′ in a given table and column. So why not share it. All you need to do is set the variable values in first 4 lines of code below:
SET @tblname = "tablename"; SET @colname = "columnname"; SET @lookfor = "'domain1'"; SET @replacewith = "'domain2'"; SET @qry = CONCAT('UPDATE ',@tblname, ' SET ', @colname, ' = REPLACE(' ,@colname, ',', @lookfor, ',',@replacewith,')'); PREPARE QUERY FROM @qry; EXECUTE QUERY;
Obviously, you can use this technique to construct any MySQL query.