Is it possible to search within a MySQL JSON array in a case insensitive manner? e.g. with the table:

create table test (id int primary key, tags json);
insert into test (id, tags) values (1, '["Lorem ipsum", "dolor", "sit"]'), (2, '["foo", "bar"]');


This will match:

select id from test where json_search(tags, 'one', 'Lorem%') is not null


But this will not:

select id from test where json_search(tags, 'one', 'lorem%') is not null


Ideally I'd like to be able match both cases. 

Running on 5.7.16 Percona XtraDB Cluster
Other case, when You can not change data and must have proper result:

select 
    id 
from test 
where json_search(UPPER(tags), 'one', UPPER('lorem%')) is not null


will be slower of course, so need test on real data-size