By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE some_table (
id INT,
name VARCHAR(500)
)
INSERT INTO some_table (id, name) values
(1,'{"en":"Professional Association","de":"Berufsverband","uk":null}'),
(2,'{"en":"Test1","de":"Test2","uk":"Test3"}'),
(3,'{"en":"Test4","de":"Test5","uk":"Berufsverband"}')
Records: 3 Duplicates: 0 Warnings: 0
SELECT * FROM some_table
| id | name |
|---|---|
| 1 | {"en":"Professional Association","de":"Berufsverband","uk":null} |
| 2 | {"en":"Test1","de":"Test2","uk":"Test3"} |
| 3 | {"en":"Test4","de":"Test5","uk":"Berufsverband"} |
select * from `some_table`
WHERE JSON_CONTAINS(JSON_EXTRACT(name, "$.*"), '"Berufsverband"')
| id | name |
|---|---|
| 1 | {"en":"Professional Association","de":"Berufsverband","uk":null} |
| 3 | {"en":"Test4","de":"Test5","uk":"Berufsverband"} |