Wildcard String Filtering Using LIKE and ILIKE in SQL

Question

Given a `products` table, find all products whose title contains 'Wireless' and whose SKU ends with '-PRO'. Return `product_id`, `title`, and `sku`.

Accepted Answer

Optimal Solution:
SELECT product_id, title, sku
FROM products
WHERE title LIKE '%Wireless%'
  AND sku LIKE '%-PRO'
ORDER BY product_id ASC;

Technical Explanation:
`%` matches zero or more characters. Combining `%Wireless%` checks for substring occurrence anywhere in `title`, and `%-PRO` matches endings.

product_id	title	sku	price
1	Wireless Bluetooth Headset	AUD-101-PRO	2499
2	Wired Gaming Mouse	ACC-202-PRO	1299
3	Wireless Ergonomic Mouse	ACC-303-STD	1899