PatternMatching_Lesson.sql

-- Task: Return products where the second character in the product name is the letter 'X'

SELECT 
	product_id,
	product_name
FROM 
	products
WHERE 
	product_name LIKE '_x%'; 

-- Task: Return products which contain the character string 'used_tablet'

SELECT 
	product_id,
	product_name
FROM 
	products
WHERE
	product_name LIKE '%used?_tablet%'
ESCAPE '?';

-- Task: Return products where the first character is a number

SELECT 
	product_id,
	product_name
FROM 
	products
WHERE 
	product_name LIKE '[0-9]%';

-- Task: Return products where the first character is a letter, and the second character is number

SELECT 
	product_id,
	product_name
FROM
	products
WHERE 
	product_name LIKE '[A-Z][0-9]%';