By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DROP TABLE
CREATE TABLE
INSERT 0 3
| json_col |
|---|
| ["Naso-pharyngé", "K", "4th", "5th", "6th", "7th", "8th"] |
| ["Pre-K", "K", "1st", "2nd", "3rd", "4th", "Naso-pharyngé"] |
| ["Pre-K", "K", "1st", "2nd", "3rd", "4th", "pouet"] |
SELECT 3
UPDATE 2
| json_col |
|---|
| ["Pre-K", "K", "1st", "2nd", "3rd", "4th", "pouet"] |
| ["K", "4th", "5th", "6th", "7th", "8th", "Respiratoire dont naso-pharyngé"] |
| ["Pre-K", "K", "1st", "2nd", "3rd", "4th", "Respiratoire dont naso-pharyngé"] |
SELECT 3