1.

How to create case insensitive query in MySQL?

Answer»

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


Discussion

No Comment Found

Related InterviewSolutions