Blog Details

WHERE Clause


* SQL WHERE Clause :-

  • The WHERE clause is used to extract only those records that fulfill a specified criterion.

Syntax :

SELECT column_name,column_name FROM table_name WHERE column_name operator value;

 Example 1:

SELECT * FROM Customers WHERE City='Rajkot';

Example 2:

SELECT * FROM Customers WHERE CustomerID=1;

* Operators in The WHERE Clause :-

1)  =                    Equal 2) <>                  Not equal. Note: In some versions of SQL this operator may be written as != 3) >                     Greater than 4)  <                    Less than 5)   >=                Greater than or equal 6)  <=                 Less than or equal 7)  BETWEEN  Between an inclusive range 8) LIKE               Search for a pattern 9) IN                   To specify multiple possible values for a column


Php mysql

Latest posts

Implementing CRUD Operations ¶

<ul> <li>Now comes the fun part. We would like t


<ol> <li><a href="

Creating Model

<ol> <li><a href="

Get Free Quote