MySQL AND Comparison Functions and Operators By Example

MySQL logical AND operator compares two expressions as well as this is a returns bollean data like as a true if both of the expressions are true.

Comparison Functions and Operators – MySQL

mysql tutorial, if, like, contains, comparison, operators, bitwise operators and between.

TRUE FALSE NULL
TRUE TRUE FALSE NULL
FALSE FALSE FALSE FALSE
NULL NULL FALSE NULL

set operators in sql

MySQL AND operator examples

SELECT 
    membername, 
    place, 
    location
FROM
    members
WHERE
    place = 'INDIA' AND location = 'GJ';

Example :

SELECT    
	membername, 
	place, 
	location, 
	creditlimit
FROM    
	members
WHERE place = 'INDIA'
	AND location = 'GJ'
	AND creditlimit > 100000;

I hope you get an idea about WHERE, AND, OR, IN, NOT IN.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.