SQL LIKE


David Haertzen David Haertzen, Tutorial Author
Check out our
Data Warehousing Tutorial.
Previous | Next

SQL > SQL Advanced > SQL LIKE


What is SQL LIKE?

The SQL LIKE operator enables a comparison to a part of a string using the % wild card character.

Why Use SQL LIKE?

The SQL LIKE operator is a powerful way to check for matching strings. It is often used for interactive display of lists.


How To Use SQL LIKE

SQL LIKE is used as follows.

SQL LIKE Syntax

 
SELECT <column_list>
FROM <table_name>
WHERE <column_name> LIKE <like_condition>
 

The <like_condition> supports the following patterns:

  • 'ABC%' - where a string begins with the letters 'ABC'
  • '%XYZ' - where a string ends with the 'XYZ'
  • '%TUV%' - where the string contais 'TUV' anywhere

SQL LIKE Example

The following example lists rows from the branch table where branch_name begins with the leading characters 'San'.

Here are the contents of the table:

Table: BRANCH
branch_nbrbranch_nameregion_nbremployee_count
108New York10010
110Boston1006
212Chicago2005
404San Diego4006
415San Jose4003

This SQL Statement with LIKE is executed:

 
SELECT branch_nbr, branch_name, employee_count
FROM branch
WHERE branch_name LIKE 'San%'
 

Here is the result.

branch_nbrbranch_nameemployee_count
404San Diego6
415San Jose3

Copyright© 1999-2015, First Place Software, Inc.