Can anyone tell me if this is a good usage of "LIKE" query
select p.productid, p.prodname, p.prodcode, c.catname from products p, categories c
where p.productid like "%acne%" or p.prodname like "%acne%" or p.prodcode like "%acne%" or c.catname like "%acne%" ORDER BY RAND();
using "LIKE" condition in multiple fields to search on something is kinda
messy to me. Are there any other better idea on how to optimize that query?
Any help is highly appreciated.