SELECT product FROM product WHERE product LIKE "%Scanner%"
Find all the product whose name contains the word "Scanner".
SELECT product FROM product WHERE product LIKE `` % Scanner % ''
select product from product where product like value
Find all the product whose name contains the word `` Scanner '' .