Title - % wildcard character Tags - sql characters programming
The % sign is a wildcard character which can be used with the LIKE operator.
% is used to match 0 or more missing letters in the pattern.
Example:
SELECT * FROM movies WHERE name LIKE ‘A%’;
A% will match all movies that begin with the letter A.
Similarly,
%a would match all movies that end with the letter ‘a’.
% can be used before and after a pattern:
SELECT * FROM movies WHERE name LIKE ‘%man%’;
In this example, any movie with the word ‘man’ in its title will be returned in the result.