MySQL SQL

MySQL Wildcards

Use wildcard characters in pattern searches.

SELECT * FROM products
WHERE name LIKE '_able%';

% matches zero or more characters; _ matches exactly one. Escape wildcard characters when they should be treated literally.