danbarrese
12/19/2016 - 7:04 PM

replace text in each record

replace text in each record

UPDATE ppc_property_name_value
SET value = REPLACE(value, 'localhost:8080', 'localtwdevbox:8080')
WHERE value LIKE '%localhost:8080%';