how to find size of json array in mysql?

Question

MySQL

I need to find out the size of the JSON array in the trigger, but I don’t know how to find it out, I know that it’s possible like this

INSERT INTO new_table SET new_tablecol = NEW.content->'$[0]';

But how exactly do you know the size?

Answer 1

JSON_LENGTH