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.
MySQL AND operator examples
SELECT membername, place, location FROM members WHERE place = 'INDIA' AND location = 'GJ';
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.