SQL LIKE ClauseTutorials

SQL Like Clause

Tips>>SQL

The LIKE operator is applicable in case of character columns.It allows for a comparison of one string value with another string value which is not identical. We use two wildcards (% and _ ) for this purpose.The LIKE condition can be used in any valid SQL statement - select, insert, update, or delete. LIKE is another keyword that is used in the WHERE clause.

The Syntax of LIKE pattern is :-

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

EXAMPLE # I:-

We will use the Name Table to illustrate the SQL LIKE clause usage:-

FIRST NAME	LAST NAME	ADDRESS
Deepali	Shah	Prithvi Classic
Nirvi	Vora	Raj Gardens
Krupa	Desai	Kunj Dham
Deesha	Shah	Raghunath Palace

If you want to select all Name having FirstName starting with 'D' you need to use the following SQL statement:

SELECT *FROM NAME WHERE First Name LIKE 'D%'

RESULT:-

FIRST NAME	LAST NAME	ADDRESS
Deepali	Shah	Prithvi Classic
Deesha	Shah	Raghunath Palace

If you don't find what you are looking for. Please click here to submit your query, our experts will reply soon.

News / Updates New version of cheque printing software is up. Can configure date in box. http://VirtualSplat.com/cp6.exe

E-mail : sales at virtualsplat dot com
Phone : +91 022 28067978