MySQL Operator Table 
------------------------------
EQUAL 	 = 
 OR 	  ||
AND  	&&
GRATER THEN EQUAL 	>=
GRATER THEN  	>
LESS THEN  	<
LESS THEN OR GRATER THEN  	<>
NOT EQUAL OR EQUAL 	!=
SUBTRACTION   	-
ADDITION  	+
MULTIPLICATION  	*
DIVISION 	/
MODULUS  	%
UNARY MINUS  	-
UNARY BIT INVERSION  	~


MySQL Logical Operators Symbol
-------------------------------
Logical NOT 	NOT, !
Logical AND 	AND, &&
Logical OR 	OR, ||
Logical XOR 	XOR


// --- samples
SELECT CASE WHEN 1>0 THEN 'true' ELSE 'false' END;

SELECT CASE 1 WHEN 1 THEN 'one'  WHEN 2 THEN 'two' ELSE 'more' END;

SELECT IF(1<2,'yes','no');