SELECT
productName
FROM Products
WHERE
productName LIKE '%en%'
productName
-----------
pencil
pen
SELECT
productName
FROM Products
WHERE
productName LIKE '_en'
productName
-----------
pen
SELECT
productName
FROM Products
WHERE
productName LIKE 'p[b-f]%'
productName
-----------
pencil
pen
SELECT
productName
FROM Products
WHERE
productName LIKE 'p[^b-f]%'
productName
-----------
paper
Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.
Comments (1)
Commented: