SELECT ..., 1 AS `level`
UNION
SELECT ..., `cte`.`level` + 1SELECT GROUP_CONCAT(`json`)
FROM JSON_TABLE(
'{"1":1,"2":1,"72":3}',
'$.*' COLUMNS(`json` INT PATH '$')
) as `t`;
| GROUP_CONCAT(`json`) |
| -------------------- |
| 1,1,3 |year_end < 2014 OR year_start > 2018NOT(year_end < 2014 OR year_start > 2018)!(a | b) === (!a) & (!b) и приведём условие к виду:year_end >= 2014 AND year_start <= 2018
--UPDATE stats SET NEW.globalnum = NEW.num1 + NEW.num2;
++SET NEW.globalnum = NEW.num1 + NEW.num2;