SQL AND Like Operator

The SQL AND Like Operator work with WHERE clause to find and search for a specified pattern in a column of table. The AND Like Operator help you to find and search for a specified records from a table in database based upon the AND operator condition.

Understand with Example

The Tutorial illustrates an example from SQL AND Like Operator. In this Tutorial, the code create a Table Stu_Table using create table Statement. The insert into statement add or insert a records to the table Stu_Table.

The Select statement retrieve the record from table Stu_Table.

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

Syntax

The below Syntax helps you to fetch the records from the table. The Like query is used to find and search for a specified records from a table in database..

SELECT ColumnName(s)
FROM TableName
WHERE ColumnName LIKE pattern

Query

The given below Query fetch the record from table 'Stu_Table using WHERE clause, which restrict the records based upon the Like Query, that is used to find and search for a specific records from a table Stu_Table.

The % (wildcard) is used to specify wildcards, which indicates missing letters in the pattern before and after the pattern.

In this code, we want to select the Stu_Table begin with a stu_name "k" whose id is"1".The AND operator is used to satisfy the both condition. If the both condition is true returns you a record from table. The record display a Stu_Name begin with "k" whose id is "1".

select * from Stu_Table
where stu_name like 'k%'AND stu_id = 1

Result

Stu_Id	Stu_Name	Stu_Class
1	Komal	10
1	Komal	10

Related Tags for SQL AND Like Operator:

«Previous Index Next»