2 lines
233 B
MySQL
2 lines
233 B
MySQL
|
update base_module set f_property_json = CONCAT(SUBSTR(f_property_json,1,length(f_property_json)-1), ',"webType":2}') where f_type = 3 and f_category = 'Web' and f_property_json is not null and f_property_json not like '%webType%';
|