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" }'), ('{