Understanding SQL Comparison tool and Operators

Contrasting different operands or factors in view of various conditions is the essential thing which is done in each program we make for deciding uniformity or imbalance between two operands,So today we are here with a little scrap

Understanding sql comparison tool and Operators which will clarify about all the examination administrators utilized as a part of PHP in most least demanding way.

Examination administrators are for the most part utilized as a part of the WHERE statement to figure out which records to choose.

Here are some examination administrators which can be utilized as a part of sql comparison tool:

=               Equal
<>              Not Equal
<>              Not Equal
!=              Not Equal
>               Greater Than
>=              Greater Than or Equal
<               Less Than
<=              Less Than or Equal
IN ( )          Matches a value in a list
NOT             Negates a condition
BETWEEN         Within a range (inclusive)
IS NULL         NULL value
IS NOT NULL     Non-NULL value
LIKE            Pattern matching with % and _
EXISTS          Condition is met if subquery returns at least one row

 

So how about we figure out how we can utilize these administrators

Imbalance Operator

In sql comparison tool there are two approaches to test for imbalance in a question. You can utilize either the <> or != administrator.

Taking an illustration

SELECT *
FROM members
WHERE member_name<> 'deepak';

 

It can likewise be composed as

SELECT *
FROM members
WHERE member_name!= 'deepak';

 

Advancing we should find out about Equality Operator

In sql comparison tool you can utilize the = administrator to test for equity in an inquiry.

Illustration:

SELECT *
FROM members
WHERE member_name = 'deepak';