Percentage in WHERE

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers

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 '|'

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results