MySQL logical OR operator compares two expressions as well as this is a returns boolean data like as a true if any single of the expressions are true.
Comparison Functions and Operators – MySQL
mysql tutorial, if, like, contains, comparison, operators, bitwise operators and between.
MySQL OR Operator Example
SELECT membername, place FROM members WHERE place = 'INDIA' OR place = 'JAPAN';
SELECT membername, place, creditLimit FROM members WHERE(place = 'INDIA' OR place = 'JAPAN') AND creditlimit > 100000;
SELECT membername, place, creditLimit FROM members WHERE place = 'INDIA' OR place = 'JAPAN' AND creditlimit > 10000;
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.