Q&A for Drupal developers and administrators
CREATE TABLE #product(product_name VARCHAR(100)); INSERT INTO #product VALUES ('prouct'), ('pro%duct'), ('product%'); select * from #product where product_name like '%|%%' ESCAPE '|'