Database FAQ: How do I do a case-insensitive database search?
Answer: When performing a database search using MySQL, PostgreSQl, SQL Server, Oracle, etc., I convert the results of the query to uppercase using the
UPPER function, and make sure my search parameters are also in uppercase. Here's an example of how I do this when searching on the
first_name field of an
Employees database table: