Perform Flexible Multi-Column Search with LIKE and ILIKE

SELECT
    *
FROM
    products
WHERE
    product_name ILIKE '%search_term%'
    OR description ILIKE '%search_term%'
    OR category ILIKE '%search_term%';

How it works: This query demonstrates how to perform a flexible search across multiple text-based columns in a table. By combining the LIKE (or ILIKE for case-insensitive search, common in PostgreSQL) operator with wildcards ('%') and multiple OR conditions, you can check if a 'search_term' exists in any of the specified columns. This pattern is fundamental for implementing a user-friendly search functionality where users expect relevant results even if their query matches only a part of the data in different fields.