How to link two fields in a database?

Question

MySQL

Hello, there is a table boxin it there is a field itemsin the format jsonstructure like this

[
  {
    "id": 1,
    "params" : []
  },
  {
    "id": 2,
    "params" : []
  }
]

How can I get elements from another table using id?

Answer 1

If you don't have an older version of mysql. Very old because json is very recent.
It will probably turn out https://dev.mysql.com/doc/refman/5.7/en/json-searc...
But there you need to specify the exact paths to the variables.
As far as I can see, walking through the array and comparing each element will not work.
There is also no support for in() and some other functions.

Answer 2

Is it just to try it out or do you want to be so perverted in production?