Home Sql SQL % Wildcards

SQL % Wildcards
Posted on: December 20, 2008 at 12:00 AM

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

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

Related Tags for SQL % Wildcards:
sql, c, database, search, data, sed, char, searching, character, tab, wildcard, characters, for, cte, base, wildcards, ld, ear, e, il, use, from, in, as, m, ca, arc, ase, rc, s, at, rac, ha, ea, ar, act, rds, s, s, rd, cards, chi, ab, on, om, o

«Previous Index Next»