By 25/02/2016 3 Comments

SQL Operators In WHERE Clause

  • SQL uses the following conditional operators in WHERE clause to filter the database result.

Operator Description
= Equal
<> Not equal. Note: In some versions of SQL this operator may be written as !=
> Greater than
< Less than
>= Greater than or equal
<= Less than or equal
BETWEEN Specify range between any two values
LIKE Search for a pattern
IN Select/Retrieve multiple values as a list of a single table column

Syntax:

SELECT table_column1, table_column2, table_column3
FROM table_name
WHERE table_column1 condition value;

Example:

SELECT user_name, user_fathers_name
FROM sm_users
WHERE user_name = "demo admin";






← Previous Tutorial


Posted in: Sql

Leave your valuable Comment

Have a natural attraction for women cosmetics and replica watches uk clothes, no
more than two for men the most attractive one, is to make their own driving experience, happy and can serve as the facade of the car, another is to highlight the taste edify sentiment rolex replica watch. The replica rolex is undoubtedly the most fashionable accessories, wear a suit to attend the activities, but also get a decent match on the replica watches .