The following SQL statement selects all customers with a City starting with any character, followed by "ondon":
Example
SELECT * FROM Customers
WHERE City LIKE '_ondon';
WHERE City LIKE '_ondon';
The following SQL statement selects all customers with a City starting with "L", followed by any character, followed by "n", followed by any character, followed by "on":
Example
SELECT * FROM Customers
WHERE City LIKE 'L_n_on';
WHERE City LIKE 'L_n_on';
Practice Excercise Practice now