Search Tutorials

Latest Questions

Failed to run Online Quiz Application in JSP
Hi, I have been following your following link to run the online quiz application, but I failed to get the result scre
Pass by Reference
Hi Friends, What is Pass by value and Pass by Reference?can u please explain with examples.is java supports Pass by r
no driver
i am having problem connecting to DB2 database fro netbeans: program: import java.sql.*; import java.lang.*; i
min project with vb
i have do the min project with VB Frantend and oracle backend
Some additions for my previous question
This is the question I posted several hours ago: "I'm trying to write a program that has a text field for input, two bu
Writing a GUI program
Hello everyone! I'm trying to write a program that has a text field for input, two buttons and the output text area. A
How to display current date in textbox
Hi guys, I'm really need your help. This is my source code. <% if (status.equals("pending") && penanda==0)
Methods in Java
Hello. Currently i am involved in a group project and we have each been given a specific part of code to create our joi
how to record qvga video using j2me
hello if it is possible how i can record qvga video usin j2me?
how to record qvga video using j2me
hello if it is possible how i can record qvga video usin j2me?
All Questions...

Comments

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

� View all related tutorials

Related Tags: sql mysql c table data ui datatypes types type tutorial field name ria create tab ie example with to datatype

Leave your comment:
Name:
Email:
URL:
Title:
Comments:
Enter Code:
	Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted. No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.