MySQL SQL

MySQL LIKE

Match text using a pattern.

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

% matches any number of characters and _ matches one character. Matching can depend on the column collation.