SQL WHERE LIKE

SQL WHERE LIKE Wildcard

WHERE LIKE determines if a character string matches a pattern.

WHERE LIKE supports two wildcard match options: % and _.

Use WHERE LIKE when only a fragment of a text value is known.

Problem: List all products that are packaged in jars.

copy

copied to clipboard

SELECT *
  FROM Product
 WHERE Package LIKE '%jars%'

SELECT *
  FROM Product
 WHERE Package LIKE '%jars%'

LIKE syntax.

SELECT column-names
  FROM table-name
 WHERE column-name LIKE value 

Wildcard characters allowed in value are % (percent) and _ (underscore).

• % (percent) matches any string with zero or more characters.
• _ (underscore) matches any single character.

copy

copied to clipboard

SELECT Id, ProductName, UnitPrice, Package
  FROM Product
 WHERE ProductName LIKE 'Ca%'

SELECT Id, ProductName, UnitPrice, Package
  FROM Product
 WHERE ProductName LIKE 'Ca%'

copy

copied to clipboard

SELECT Id, ProductName, UnitPrice, Package
  FROM Product
 WHERE ProductName LIKE 'Cha_' OR ProductName LIKE 'Chan_'

SELECT Id, ProductName, UnitPrice, Package
  FROM Product
 WHERE ProductName LIKE 'Cha_' OR ProductName LIKE 'Chan_'

• Our Sql WHERE Reference
• Our Sql WHERE IN Reference
• Our Sql WHERE EXISTS Reference
• Our Sql SELECT COUNT, SUM, AVG Reference