SQL
Perform Case-Insensitive Search with LIKE
Discover how to search for patterns in string columns using the LIKE operator, enabling flexible and powerful text-based searches in your database.
SELECT id, name, description
FROM products
WHERE LOWER(name) LIKE LOWER('%search term%') OR LOWER(description) LIKE LOWER('%search term%');
How it works: This snippet demonstrates how to perform a case-insensitive search across multiple columns. The `LOWER()` function converts both the column content and the search term to lowercase before comparison with `LIKE '%search term%'`. The `%` wildcard matches any sequence of zero or more characters, allowing for partial matches anywhere within the string. This is essential for search bar functionalities.