SELECT c.name
  FROM category c
 WHERE c.name like '%an%'
 UNION 
SELECT p.name
  FROM product p
 WHERE p.name like '%an%'