Online Training Spring Hibernate Training in Delhi R Programming Training Course Big Data and Hadoop Training Java Training

SQL % Wildcards

SQL wildcards used for searching one or more characters from data in a database.

Ads

SQL % Wildcards

     

SQL wildcards used for  searching one or more characters from data in a database.

 

 

 

 

 

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 % Wildcards Syntax

SELECT ColumnName(s)
FROM TableName
WHERE ColumnName LIKE pattern

SQL % Wildcards 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

Advertisements

Ads
Share on Google+Share on Google+

SQL % Wildcards

Posted on: December 20, 2008 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

Ads
 

Discuss: SQL % Wildcards  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0

Ads

 

Ads