FUNCTIONS and OPERATORS
In the following section, we have given a list of FUNCTIONS and OPERATORS in MySQL as anyone can view the FUNCTIONS at a glance and jump immediately to his/her requirement.
| MySQL Function & Operators | Description |
|---|---|
| Introduction of MySQL functions and operators | Types of MySQL functions and operators. |
| MySQL Comparison Functions and Operators | Some Comparison Functions and Operators are – Between andCOALESCE()NULL Safe equal to operator (<=>)Equal operator(=)Greater than or equal operator(>=)Greater than operator(>)GREATEST()IN()INTERVAL()IS NOT NULLIS NOTIS NULLISIS NULL()LEAST()LESS THAN OR EQUAL OPERATOR(<=)LESS THAN OPERATOR(<)LIKENOT BETWEEN ANDNOT EQUAL OPERATOR(<>,!=)NOT IN()NOT LIKESTRCMP() |
| MySQL Logical Operators | MySQL logical AND operator compares two expressions and returns true if both of the expressions are true. Some Logical Operators are – And operatorNot operatorOr operatorXor operator |
| MySQL Control Flow Functions | Some Control Flow Functions are – Case operatorIF()IFNULL()NULLIF() |
| MySQL String Functions | Some String Functions in MySQL are – ASCIIBINBIT_LENGTHCHAR_LENGTHCHARCHARACTER_LENGTHCONCAT_WSCONCATELTEXPORT_SETFIELDFIND_IN_SETFORMATHEXINSERTINSTRLCASELEFTLENGTHLIKELOAD_FILELOCATELOWERLPADLTRIMMAKE_SETMIDNOT LIKENOT REGEXPOCTET_LENGTHORDPOSITIONQUOTEREGEXPREPEATREPLACEREVERSERIGHTRLIKENOT RLIKERPADRTRIMSOUNDEXSOUNDS_LIKESPACESTRCMPSUBSTRSUBSTRING_INDEXSUBSTRINGTRIMUCASEUNHEXUPPER |
| MySQL Mathematical Functions | Some Mathematical Functions in MySQL are – ABS()ACOS()ASIN()ATAN2()ATAN()CEIL()CEILING()CONV()COS()COT()CRC32()DEGREES()DIVDIVISIONEXP()FLOOR()LN()LOG()LOG2()LOG10()MOD()OCT()PI()POW()POWER()RADIANS()RAND()ROUND()SIGN()SIN()SQRT()TAN()TRUNCATE()FORMAT() |
| MySQL Date and Time Functions | MySQL Date and Time Functions are used in various type of date and time operation. |
| MySQL Encryption and Compression Functions | MySQL Encryption and Compression Functions are used to encrypt and decrypt a string. Some Encryption and Compression Functions in MySQL are – AES_DECRYPT()AES_ENCRYPT()COMPRESS()DECODE()DES_DECRYPT()DES_ENCRYPT()ENCODE()ENCRYPT()MD5()OLD_PASSWORD()PASSWORD()SHA1()UNCOMPRESS()UNCOMPRESSED_LENGTH() |
| MySQL Bit Functions | Some Bit Functions in MySQL are – BIT_COUNTBITWISE ANDINVERT BITSBITWISE ORBITWISE XORLeft shiftRight shift |
| MySQL Information Functions | Some Information Functions in MySQL are – BENCHMARK()CHARSET()COERCIBILITY()COLLATION()CONNECTION_ID()CURRENT_USER(), CURRENT_USERDATABASE()FOUND_ROWS()LAST_INSERT_ID()SCHEMA()SESSION_USER()SYSTEM_USER()USER()VERSION() |
Leave a Reply