VOOZH about

URL: https://www.geeksforgeeks.org/sql/sql-like/

⇱ SQL LIKE Operator - GeeksforGeeks

  • Courses
  • Tutorials
  • Interview Prep

SQL LIKE Operator

Last Updated : 16 Apr, 2026

The SQL LIKE operator is used to search for a specific pattern within a column’s text data. It works with wildcard characters to match partial strings, making it useful for flexible filtering.

  • % represents any sequence of characters
  • _ represents a single character

Example: First, we create a demo SQL database and table, on which we will use the LIKE Operator command.

👁 table

Query:

SELECT * FROM Employees
WHERE EmpName LIKE 'A%';

Output:

👁 like-opr

Syntax:

SELECT column1, column2, ...
FROM table_name
WHERE column_name LIKE pattern;
  • column_name: The column to be searched.
  • pattern: The pattern to search for, which can include wildcard characters.

Wildcard Characters with the SQL LIKE Operator

Wildcards are used with the LIKE operator to search for specific patterns in strings. Wildcard characters substitute one or more characters in the string. There are four wildcard characters in SQL:

  1. % (Percent): Represents zero or more characters.
  2. _ (Underscore): Represents a single character.
  3. [] (Square Brackets): Represents any single character within brackets.
  4. - (Hyphen): Specify a range of characters inside brackets.
PatternMeaning
'a%'Match strings that start with 'a'
'%a' Match strings that end with 'a'
'a%t'Match strings that contain the start with 'a' and end with 't'.
'%wow%'Match strings that contain the substring 'wow' in them at any position.
'_wow%'Match strings that contain the substring 'wow' in them at the second position.
'_a%'Match strings that contain 'a' at the second position.
'a_ _%'Match strings that start with 'a and contain at least 2 more characters.

Examples of SQL LIKE Operator

Let's understand LIKE operator in SQL with examples. First, we will create a demo SQL database and table, on which we will use the SQL LIKE Operator command.

👁 supplier

Example 1 : Match Names Starting with 'Ca'

Retrieve SupplierID, Name and Address from suppliers table, where supplier name starts form Ca.

SELECT SupplierID, Name, Address
FROM Supplier
WHERE Name LIKE 'Ca%';

Output:

👁 Supplier-6

Example 2: Match Addresses Containing 'Kungsgatan'

Retrieve entire table, where address contains Kungsgatan.

SELECT *
FROM Supplier
WHERE Address LIKE '%Kungsgatan%';

Output:

👁 supplier-2

Example 3: Match Names Where 'afé' Appears in the Second Position

Retrieve the SupplierID, Name and Address of suppliers whose Name has "afé" starting from the second position.

SELECT SupplierID, Name, Address
FROM Supplier
WHERE Name LIKE '_afé%';

Output:

👁 Supplier-3

Example 4: Using LIKE with AND for Complex Conditions

Retrieve suppliers from Madrid with names starting with "C":

SELECT SupplierID, Name, Address
FROM Supplier
WHERE Address LIKE '%Madrid%' AND Name LIKE 'C%';

Output:

👁 supplier-4

Example 5: Using NOT LIKE for Exclusion

To retrieve all suppliers whose name does not contain "Co"

SELECT SupplierID, Name, Address
FROM Supplier
WHERE Name NOT LIKE '%Co%';

Output:

👁 supplier-8

Note: Case sensitivity with LIKE depends on the database, use BINARY in MySQL, COLLATE in others and ILIKE in PostgreSQL for case-insensitive matching.

Comment
Article Tags: