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
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.
SELECT * FROM members WHERE member_name = 'deepak';