Published May 21, 2021Updated Aug 18, 2022
Contribute to Docs
LIKE operator returns
TRUE if its first text argument matches the wildcard pattern in its second argument.
LIKE is commonly used in a
WHERE clause to select rows based on a column matching a given string pattern.
SELECT * FROM table WHERE column LIKE pattern;
pattern is made up of a string that includes the following wildcards:
- The percent character
%matches zero to any number of arbitrary characters.
- The underscore character
_matches a single arbitrary character.
Select all rows where the
column‘s value has “H” as the second character:
SELECT * FROM table WHERE column LIKE '_H%';
The matches would include values like “THE” and “WHERE” but not “HOUSE”, or “BREATH”.
More examples are shown in the wildcards entry.
Looking to contribute?
- Learn more about how to get involved.
- Edit this page on GitHub to fix an error or make an improvement.
- Submit feedback to let us know how we can improve Docs.
Learn SQL on Codecademy
Analyze Data with SQLLearn to analyze data with SQL and prepare for technical interviews.
Includes 8 Courses
Design Databases With PostgreSQLLearn how to query SQL databases and design relational databases to efficiently store large quantities of data.
Includes 5 Courses