SQL > SQL Commands > Like

LIKE is another keyword that is used in the WHERE clause. Basically, LIKE allows you to do a search based on a pattern rather than specifying exactly what is desired (as in IN) or spell out a range (as in BETWEEN). The syntax is as follows:

SELECT "column_name"
FROM "table_name"
WHERE "column_name" LIKE {PATTERN};

{PATTERN} often consists of wildcards. We saw several examples of wildcard matching in the previous section. Below we use an example to see how wildcard is used in conjunction with LIKE:

Table Store_Information

Store_NameSalesTxn_Date
LOS ANGELES1500Jan-05-1999
SAN DIEGO250Jan-07-1999
SAN FRANCISCO300Jan-08-1999
BOSTON700Jan-08-1999

We want to find all stores whose name contains 'AN'. To do so, we key in,

SELECT *
FROM Store_Information
WHERE Store_Name LIKE '%AN%';

Result:

Store_NameSalesTxn_Date
LOS ANGELES1500Jan-05-1999
SAN DIEGO250Jan-07-1999
SAN FRANCISCO300Jan-08-1999

Next: SQL ORDER BY




Copyright © 2014 1keydata.com   All Rights Reserved.   Privacy Policy