UPDATE clients

SET services = REPLACE(services, 'dhcp\":\"2\"', 'dhcp\":\"5\"')

WHERE location_id=14;


UPDATE clients

SET services = REPLACE(services, 'pool\":\"2\"', 'pool\":\"5\"')

WHERE location_id=14;


UPDATE clients

SET region_id = 13

WHERE location_id=14;