SELECT count(*) as cnt
		FROM `pt_product` a
		WHERE 1  AND LOWER(`product_txt4`) LIKE LOWER('%DW%') 

Products