SQL Advanced Apps (like)

Like

The LIKE operator is used to search for a specified pattern in a column in a WHERE clause, and the syntax

SELECT column_name (s) from Table_namewhere columns_name like pattern

　　

Original table (Persons)

City

Id	LastName	FirstName	Address
1	Adams	John	Oxford Street	London
2	Bush	George	Fifth Avenue	New York
3	Carter	Thomas	Changan Street	Beijing

Example 1: Select a person from the "Persons" table above that lives in a city that starts with "N" and can use the following SQL

SELECT * from Personswhere city like ' N% '

Hint: "%" can be used to define wildcard characters (missing letters in pattern)

Example 2: Select a person living in a city that ends with "G" from the "Persons" table

SELECT * from Personswhere city like '%g '

　　

Example 3: Select a person living in a city that contains "Lon" from the "Persons" table

SELECT * from Personswhere city like '%lon% '

　　

Example 4: By using the keyword not, you can select a person who lives in a city that does not contain "lon" from the "Persons" table

SELECT * from Personswhere City does like '%lon% '

　　

SQL Advanced Apps (like)