LIKE will check if a result matches a pattern

To get all customers where the second letter of the first name starts with A,

SELECT * FROM customers
WHERE first_name LIKE '_A%'

_ matches any single character

% matches any group of characters of any length

SELECT column FROM table
WHERE column LIKE 'expression'