SQL
Perform Case-Insensitive String Search in SQL
Discover methods for conducting case-insensitive searches on text columns in SQL databases to return relevant results regardless of casing.
SELECT id, product_name FROM products WHERE LOWER(product_name) LIKE LOWER('%laptop%');
How it works: This snippet performs a case-insensitive search for products containing the word "laptop". By converting both the column value (`product_name`) and the search term (`'%laptop%'`) to lowercase using the `LOWER()` function, the query ensures that results like "Laptop", "laptop", and "LAPTOP" are all matched, providing more flexible search capabilities.