How to concatenate json arrays in Mysql?

Question

MySQL

There are lists of categories that are stored as json

and I can get them with one request

select
  categories_overprice
from
  items
where user_id = 288 and categories_overprice is not null

Question: is it possible to combine them somehow so that the query eventually returns one array to me?

Answer 1

concat, group_concat, although it is clear that these are all crooked solutions and, according to your mind, from the very beginning you should store all this as many to many.