MySQL Wildcards

MySQL Wildcard Characters

A wildcard character is used to substitute one or more characters in a string.

Wildcard characters are used with the LIKE operator.

• % - Represents zero or more characters
• _ - Represents a single character

SELECT * FROM Customers WHERE City LIKE 'ber%';