SQL LIKE query Command

You can LIKE keyword for matching and searching for records, for example if we are looking for a records with a column contains a specific string value :

Code:

SELECT * FROM Department WHERE name LIKE '%IT%'

we can also get Departments records start with IT as follows :

Code:

SELECT * FROM Department WHERE name LIKE 'IT%'

and end with IT :

Code:

SELECT * FROM Department WHERE name LIKE '%IT'

Underscore can be use as wildcard for one character space :

Code:

SELECT * FROM Department WHERE DepId LIKE '__33'

The previous SQL means to return all records with ids start with any two numbers but end with 33.

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada

Author: DrRakha
Mastermind

Posts: 2715
Have thanks: 74 time

Page 1 of 1

[ 1 post ]

Related Posts to : SQL LIKE query Command
BETWEEN SQL COMMAND -
EJB-QL IN where query -
SQL DISTINCT Command -
update query example -
Average SQL command -
using parameter with name query -
SQL LOCATE command -
query about execution -
SQL COUNT Command -
more than one parameter with name query -

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com