WHERE Clause in SQL

In SQL, you can fetch, update, and delete records in a table when a certain condition is met.  For this reason, we use WHERE clause. The most commonly used operators with WHERE clause are given below.

• Equal (=)
• Not Equal (<> or !=)
• Greater than (>)
• Less than (<)
• Greater than or Equal (>=)
• Less than or Equal (<=)

The syntax for WHERE clause is given below.

SELECT * FROM {Table_Name} WHERE {Column_Name} = {Column_Value}

You May Also Like:

DELETE Statement in SQL Comparison Operators in PHP SELECT Statement in SQL Comparison Operators Default Constraint in SQL