I got a text column with JSON arrays.

```
+-------------------------------------------------------------------------+
| code                                                                    |
+-------------------------------------------------------------------------+
| []                                                                      |
| ["5020","6420"]                                                         |
| ["4645","4775"]                                                         |
| ["6820"]                                                                |
| ["2442","2511"]                                                         |
| ["4675"]                                                                |
| ["1814","6201","6203","6209","6312","6399","7022","7311","7312","7320"] |
| ["6910","6920"]                                                         |
| ["4321","4329","4652","7112"]                                           |
| ["4332","7739"]                                                         |
+-------------------------------------------------------------------------+

```

I need to get these codes to another table as single integer values. As soon as there are millions of records I would not like to fetch these records to php/ruby/etc for this task. I'd like to make it inside MariaDB with SQL.

The question is what could be a nice approach for such query?