MySQL OR – Comparison Functions and Operators By Example

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.

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

set operators in sql

MySQL OR Operator Example

SELECT    
	membername, 
	place
FROM    
	members
WHERE place = 'INDIA' OR 
      place = 'JAPAN';

Example

SELECT   
	membername, 
	place, 
	creditLimit
FROM   
	members
WHERE(place = 'INDIA'
		OR place = 'JAPAN')
	  AND creditlimit > 100000;

Example

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.