Using the same products table which has product_id, product_name and description, your task is to find all product names that meet at least 1 of these criterias:
Hint for Condition 1: To address the case insensitivity for the word "high", you can use the LOWER function. This function converts the entire text in the 'description' column to lowercase. Once converted, apply the LIKE operator to match the lowercase version of "wireless". This ensures you capture all variations, whether it's "High", "HIGH", or "high".
| product_name |
|---|
| Smartphone Model X |
| Laptop Pro 15 |
| Smart TV 55 inch |
Using the same products table which has product_id, product_name and description, your task is to find all product names that meet at least 1 of these criterias:
Hint for Condition 1: To address the case insensitivity for the word "high", you can use the LOWER function. This function converts the entire text in the 'description' column to lowercase. Once converted, apply the LIKE operator to match the lowercase version of "wireless". This ensures you capture all variations, whether it's "High", "HIGH", or "high".
| product_name |
|---|
| Smartphone Model X |
| Laptop Pro 15 |
| Smart TV 55 inch |