Is it possible to search within a MySQL JSON array in a case insensitive manner?
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