Search with JSON in a case insensitive manner across array values
Create a table like so
create table test.users
(
id int auto_increment primary key,
identifiers json null
);
Fill the table with some sample data
insert into users (identifiers)
values ('{"names": ["Johnny", "John", "Jay"], "id": "12345z" }'),
('{