Scribd
Upload
6 views

LIKE in SQL - 1keydata

Uploaded by

vickroid007
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views

LIKE in SQL - 1keydata

Uploaded by

vickroid007
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

3/2/2016 LIKE in SQL | 1Keydata

SQL LIKE

SQL Data Warehousing CSS PHP HTML Database Normalization

SQL Tutorial
Basic SQL Commands
| COMPOSE

SQL SELECT
SQL DISTINCT
SQL WHERE SQL > SQL Commands > Like
SQL AND OR
LIKE is another keyword that is used in the WHERE clause. Basically, LIKE allows you to do a search based on a pattern rat
SQL IN
exactly what is desired (as in IN) or spell out a range (as in BETWEEN). The syntax is as follows:
SQL BETWEEN
SQL Wildcard
SELECT "column_name"
SQL LIKE FROM "table_name"
SQL ORDER BY WHERE "column_name" LIKE {PATTERN};
SQL GROUP BY
SQL HAVING {PATTERN} often consists of wildcards. We saw several examples of wildcard matching in the previous section. Below we
SQL ALIAS see how wildcard is used in conjunction with LIKE:
SQL AS
SQL SELECT UNIQUE
Table Store_Information
SQL JOIN
Store_Name Sales Txn_Date
SQL INNER JOIN
LOS ANGELES 1500 Jan-05-1999
SQL OUTER JOIN
SAN DIEGO 250 Jan-07-1999
SQL LEFT OUTER JOIN
SQL CROSS JOIN SAN FRANCISCO 300 Jan-08-1999
SQL INSERT INTO BOSTON 700 Jan-08-1999
SQL INSERT INTO SELECT
We want to find all stores whose name contains 'AN'. To do so, we key in,
SQL UPDATE
SQL DELETE FROM
SELECT *
Advanced SQL FROM Store_Information
SQL UNION WHERE Store_Name LIKE '%AN%';
SQL UNION ALL
SQL Inline View Result:
SQL INTERSECT
SQL MINUS Store_Name Sales Txn_Date
SQL LIMIT LOS ANGELES 1500 Jan-05-1999
SQL TOP SAN DIEGO 250 Jan-07-1999
SQL Subquery SAN FRANCISCO 300 Jan-08-1999
SQL EXISTS
SQL CASE
SQL DECODE
SQL AUTO INCREMENT
Low EMI Car Loans
Compare Car Loan Offers from Top Banks. 20+ Options. Apply Now!
SQL IDENTITY
SEQUENCE & NEXTVAL

SQL Functions
SQL Average
Exercises
SQL COUNT
For these exercises, assume we have a table called User_Sales with the following data:
SQL MAX
SQL MIN Table User_Sales
SQL SUM
SQL ROUND First_Name Last_Name Birth_Date Gender Joi n_Date Total_Sales

String Functions Sophie Lee Jan-05-1960 F Apr-05-2015 500


SQL CAST Richard Brown Jan-07-1975 M Apr-05-2015 200
SQL CONVERT Jamal Santo Oct-08-1983 M Apr-09-2015 350
SQL CONCATENATE Casey Healy Sep-20-1969 M Apr-09-2015 80
SQL SUBSTRING Jill Wilkes Nov-20-1979 F Apr-15-2015 210
SQL INSTR
SQL TRIM 1) 1. Which of the following SQL statement is valid? (There can be more than one answer)
a) SELECT First_Name, Last_Name FROM User_Sales WHERE First_Name LIKE 'A%' Last_Name LIKE 'W%';
http://www.1keydata.com/sql/sqllike.html 1/2
3/2/2016 LIKE in SQL | 1Keydata
SQL LENGTH a) SELECT First_Name, Last_Name FROM User_Sales WHERE First_Name LIKE 'A%' Last_Name LIKE 'W%';
SQL REPLACE b) SELECT First_Name, Last_Name FROM User_Sales WHERE First_Name LIKE 'J%' AND Last_Name LIKE 'W%';
SQL TO_DATE c) SELECT First_Name, Last_Name FROM User_Sales First_Name LIKE 'J%' AND Last_Name LIKE 'W%';
d) SELECT First_Name, Last_Name FROM User_Sales WHERE First_Name LIKE 'J%', Last_Name LIKE 'W%';
Date Functions
2. How many records will be returned by the following query? (Assuming the database is configured to be case-insensitive
SELECT * FROM User_Sales WHERE Last_Name LIKE '%l_e%';

3. How many records will be returned by the following query? (Assuming the database is configured to be case-insensitive
SELECT * FROM User_Sales WHERE First_Name LIKE '%a%' OR Last_Name LIKE '%e%';

Show Answers

Next: SQL ORDER BY

Zendesk ­ Official Site


Zendesk Makes Communicating With Customers Easy + Efficient. Try Now

Copyright © 2016 1keydata.com All Rights Reserved Privacy Policy About Contact

http://www.1keydata.com/sql/sqllike.html 2/2

You might also like