1MariaDB does not natively implement the 'JSON' data type but it uses it as an
2alias for 'LONGTEXT' for compatibility reasons
1UPDATE test
2SET field = IF(something == 1{CONDITION}, 1 {NEW VALUE}, field)
3WHERE `id` = 5
1propabaly you are using a reserved keyword as column name, just add `` around the coulumn name.