By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( p.data, '$[*]' columns (name varchar(50) path '$.name') ) x where x.name <> ' at line 3
id | name |
---|---|
1 | one |
1 | two |
2 | four |