MySQL

Where in MySQL
Previous Home Next

The Where command is used to filter the results according to the applied conditions. Here is the syntax of select statement.

SELECT expressions
FROM tables
WHERE columnname operatorvalue;

There are some operators used in Where clause which is given below:

OperatorDescription
=Equal
<>Not equal to(somtimes it may be written as !=)
>Greater than
<Less than
<=Less than equal to
>=Greater than equal to
andBoth conditions follow
orAny one condition follow
BetweenWithin a Range

 

Here given some example which follow above conditions

In the following examples i have created a new table from the existing database of name school off name studadr as image given below

Example

SELECT * 				//show all values
FROM studadr 				//studadr is tablemname
WHERE locatn = 'central' ;		//condition is given

output become

Example

SELECT * 			//show all values
FROM studadr			//studadr is a tablename
WHERE locatn != 'central' ;	//not equal to condition is given

output become

Example


SELECT * 			//show all values
FROM studadr			//studadr is a tablename
WHERE aid  > = 108 ;		//greater than equal to condition is given

output become

Example

SELECT * 					//show all values
FROM studadr					//studadr is a tablename
WHERE locatn ='noida' and state='delhi';	//AND conditions is given

output become

Note:

Both the conditions written on where clause should follow to get the output, if any one fails then no output will be shown.

Example

SELECT * 						//show all values
FROM studadr						//studadr is a tablename
WHERE  locatn ='noida' OR state='delhi';;		//OR conditions is given

output become

Note:

Any of the conditions written in where clause satisfy to get the output, if all the conditions fails then no output will be shown.

Example

SELECT *					//shoe all values
FROM studadr					//studadr is a tablename
WHERE aid BETWEEN '101' AND '111' 		//AND conditions is given

output become

Note:

In the above condition the lower and upper limits also gets count into the output.

Previous Home Next

Tolal:0 Click:

Show All Comments

Did not find what you were looking for leave your name and message. We will revert within 24 hours
Name:
eMail:
Comment / Feedback: