In products table, category and description columns. Sometimes a product will mistakenly updated in wrong category. Example: Rice should be in Groceries category but it is in General category. Now i use below query to update the category
update products set category = 'Groceries' where description like '%egg%' or description like '%Dosa%'
or description like '%Curd%' or description like '%tomm%' or description like '%dal%' or
description like '%rice%' or description like '%sugar%' or description like '%oil%' or description like '%chilli%'
or description like '%milk%' or description like '%boost%'
Is there query to combine the LIKE and IN operator or is there any query to reduce above query length ? (like is mandatory for to search products)
Mark as Answer if its helpful to you
---
Srihari