LIKE Operator
The LIKE operator is used for searching a specified pattern in the column. In this example we will show you how to use the Like operator to get the related results from the database.
Understand with Example
The Tutorial illustrates an example from LIKE Operator. In this example, The create table statement helps you to create a table 'Stu_Table'. Insert a records or rows into a table using insert into statement. Once your records is added into table, The records from a table can be retrieved by select statement in SQL.
Create Table Stu_Table
create table Stu_Table(Stu_Id integer(2), Stu_Name varchar(15), Stu_Class varchar(10));
Insert data into Stu_Table
insert into Stu_Table values(1,'Komal',10); insert into Stu_Table values(2,'Ajay',10); insert into Stu_Table values(3,'Rakesh',10); insert into Stu_Table values(4,'Bhanu',10); insert into Stu_Table values(5,'Santosh',10); insert into Stu_Table values(1,'Komal',10); |
Stu_Table
Stu_Id | Stu_Name | Stu_Class |
1 | Komal | 10 |
2 | Ajay | 10 |
3 | Rakesh | 10 |
4 | Bhanu | 10 |
5 | Santosh | 10 |
1 | Komal | 10 |
SQL LIKE Syntax
SELECT ColumnName(s) FROM TableName WHERE ColumnName LIKE pattern |
SQL Like Operator Query
Now we want to select the persons name those name starts with "k" from the table above.
select * from Stu_Table where stu_name like 'k%' |
Result
Stu_Id | Stu_Name | Stu_Class |
1 | Komal | 10 |
1 | Komal | 10 |
Now we want to select the persons name those name ends with "h" from the table above.
select * from Stu_Table where stu_name like '%h' |
Result
Stu_Id | Stu_Name | Stu_Class |
3 | Rakesh | 10 |
5 | Santosh | 10 |