I have this json data in a 'name' column, where the names of some records are stored with multi-lang support:

{"en":"Professional Association","de":"Berufsverband","uk":null}

When I run this query returns 0 records:

select * from `some_table` where lower(json_value(name,'$.*')) like lower('