By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT VERSION();
| VERSION() |
|---|
| 8.0.30 |
DROP TABLE IF EXISTS `my_table`;
CREATE TABLE IF NOT EXISTS `my_table` (
`id` SERIAL,
`data` JSON NOT NULL
);
INSERT INTO `my_table`
(`data`)
VALUES
('{"name": "à l''avenir"}'),
('{"name": "je veux"}'),
('{"name": "Que ça marche"}');
Records: 3 Duplicates: 0 Warnings: 0
SELECT `data` ->> '$.name' COLLATE utf8mb4_unicode_ci `name`
FROM `my_table`
ORDER BY `name` ASC;
| name |
|---|
| à l'avenir |
| je veux |
| Que ça marche |