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';
OR
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.
Also Read: MongoDB Interview Questions And Answers
BY Best Interview Question ON 20 Sep 2022