Computer & IT Tips By Akash Padhiyar


Mysql Operator List

Posted by Akash Padhiyar 0 Comment

List of My SQL Operator …..

Name Description
AND, && Logical AND
BINARY Cast a string to a binary string
& Bitwise AND
| Bitwise OR
^ Bitwise XOR
/ Division operator
DIV Integer division
<=> NULL-safe equal to operator
= Equal operator
>= Greater than or equal operator
> Greater than operator
IS NULL NULL value test
IS Test a value against a boolean
<< Left shift
<= Less than or equal operator
< Less than operator
LIKE Simple pattern matching
Minus operator
% Modulo operator
!=, <> Not equal operator
NOT LIKE Negation of simple pattern matching
NOT, ! Negates value
||, OR Logical OR
+ Addition operator
REGEXP Pattern matching using regular expressions
>> Right shift
RLIKE Synonym for REGEXP
SOUNDS LIKE Compare sounds
~ Invert bits
* Times operator
Change the sign of the argument
XOR Logical XOR

Akash Padhiyar

I am Akash Padhiyar Founder of,BCA MCA Tutor ,Running Web development compnay "AkashInfoTech".

More Posts - Website - Facebook

Categories: My Sql

Leave a Reply

Google Search

Popular Posts

Bigrock Hosting Prom

Bigrock Hosting PromoCode October 2016 HOSTING FEST! Flat 40% Off! Festivities ...

DotCom Domain Name a

DotCom Domain Name at Rs.99 Bigrock .Com Promocode end date for ...

Web Designer vs Web

This Infographic explain you what is role of Web Designer and ...