How to create case insensitive query in MySQL?
The standard way to perform case insensitive queries in SQL is to use the SQL upper or lower functions like the following:
select * from users where upper(first_name) = 'AJAY';
select * from users where lower(first_name) = 'ajay';
The method is to make the field you are searching as uppercase or lowercase then also make the search string uppercase or lowercase as per the SQL function.