MariaDB 10.3

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"}

id	name
1	{"en":"Professional Association","de":"Berufsverband","uk":null}
2	{"en":"Test1","de":"Test2","uk":"Test3"}
3	{"en":"Test4","de":"Test5","uk":"Berufsverband"}