如何在触发器中保存json值

Question

我们创造了一个触发器

CREATE TRIGGER `insert_category` AFTER INSERT ON `cleaner_service`
 FOR EACH ROW UPDATE users
  SET user_category = (select group_concat(concat(service_id) SEPARATOR '-') from cleaner_service where users.id=cleaner_service.user_id)
WHERE users.id=NEW.user_id

它存储类似于8-7-9的值。我想将这个值存储在json "1“、"2”、"3"中，您能告诉我如何在MYSQL中这样做吗？

请帮帮忙

Answer 1

试着：

SET user_category = concat("[",(select group_concat(concat(service_id) SEPARATOR ','),"]") from cleaner_service where users.id=cleaner_service.user_id)