Like clause is used as condition in SQL query. Like
clause compares data with an expression using wildcard operators. It is used to
find similar data from the table.
Wildcard operators
There are two wildcard operators that are used in like
clause.
- Percent sign % : represents zero, one or more than one character.
- Underscore sign _ : represents only one character.
Example of LIKE clause
Consider the following Student table.
s_id
|
s_Name
|
age
|
101
|
Adam
|
15
|
102
|
Alex
|
18
|
103
|
Abhi
|
17
|
SELECT * from Student where
s_name like 'A%';
The above query will return all records where s_name
starts with character 'A'.
s_id
|
s_Name
|
age
|
101
|
Adam
|
15
|
102
|
Alex
|
18
|
103
|
Abhi
|
17
|
Example
SELECT * from Student where
s_name like '_d%';
The above query will return all records from Student
table where s_name contain 'd' as second character.
s_id
|
s_Name
|
age
|
101
|
Adam
|
15
|
Example
SELECT * from Student where
s_name like '%x';
The above query will return all records from Student
table where s_name contain 'x' as last character.
s_id
|
s_Name
|
age
|
102
|
Alex
|
18
|
0 Comments:
Post a Comment