Functions and Operators

MySQL Function and Operator

The most used MySQL Functions and Operators are:

ABS()
ADDDATE()
ADDTIME()
AES_DECRYPT()
AES_ENCRYPT()
AND, &&
ANY_VALUE()
ASCII()
=
:=
AVG()
BENCHMARK()
BETWEEN … AND
BIN()
BINARY
&
~
|
^
CASE
CAST()
CHAR()
CHAR_LENGTH()
CHARACTER_LENGTH()
CHARSET()
COALESCE()
CONCAT()
CONCAT_WS()
CONNECTION_ID()
CONVERT()
CONVERT_TZ()
COUNT()
COUNT(DISTINCT)
CREATE_ASYMMETRIC_PRIV_KEY()
CREATE_ASYMMETRIC_PUB_KEY()
CREATE_DH_PARAMETERS()
CREATE_DIGEST()
CURDATE()
CURRENT_DATE(), CURRENT_DATE
CURRENT_TIME(), CURRENT_TIME
CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP
CURRENT_USER(), CURRENT_USER
CURTIME()
DATABASE()
DATE()
DATE_ADD()
DATE_FORMAT()
DATE_SUB()
DATEDIFF()
DAY()
DAYNAME()
DAYOFMONTH()
DAYOFWEEK()
DAYOFYEAR()
DECODE()
DEFAULT()
DEGREES()
DIV
/
ELT()
ENCODE()
=
<=>
EXP()
EXTRACT()
ExtractValue()
FIELD()
FIND_IN_SET()
FLOOR()
FORMAT()
FOUND_ROWS()
FROM_BASE64()
FROM_DAYS()
FROM_UNIXTIME()
GET_FORMAT()
GET_LOCK()
>
>=
GREATEST()
GROUP_CONCAT()
HEX()
HOUR()
IF()
IFNULL()
IN()
INSERT()
INSTR()
INTERVAL()
IS
IS_FREE_LOCK()
IS NOT
IS NOT NULL
IS NULL
IS_USED_LOCK()
ISNULL()
LAST_DAY
LAST_INSERT_ID()
LCASE()
LEAST()
LEFT()
LENGTH()
<
<=
LIKE
LOAD_FILE()
LOCALTIME(), LOCALTIME
LOCALTIMESTAMP, LOCALTIMESTAMP()
LOWER()
LPAD()
LTRIM()
MAKEDATE()
MAKETIME()
MASTER_POS_WAIT()
MATCH
MAX()
LOCATE()
MD5()
MICROSECOND()
MID()
MIN()

MINUTE()
MOD()
%, MOD
MONTH()
MONTHNAME()
NAME_CONST()
NOT, !
NOT BETWEEN … AND
!=, <>
NOT IN()
NOT LIKE
NOT REGEXP
NOW()
NULLIF()
||, OR
PERIOD_ADD()
PERIOD_DIFF()
PI()
+
Point()
POSITION()
POW()
POWER()
PROCEDURE ANALYSE()
QUARTER()
QUOTE()
RADIANS()
RAND()
RANDOM_BYTES()
REGEXP
RELEASE_ALL_LOCKS()
RELEASE_LOCK()
REPEAT()
REPLACE()
REVERSE()
RIGHT()
RLIKE
ROUND()
ROW_COUNT()
RPAD()
RTRIM()
SCHEMA()
SEC_TO_TIME()
SECOND()
SESSION_USER()
SHA1(), SHA()
SHA2()
SIGN()
SLEEP()
SOUNDEX()
SOUNDS LIKE
SPACE()
SQRT()
STR_TO_DATE()
STRCMP()
SUBDATE()
SUBSTR()
SUBSTRING()
SUBSTRING_INDEX()
SUBTIME()
SUM()
SYSDATE()
SYSTEM_USER()
TAN()
TIME()
TIME_FORMAT()
TIME_TO_SEC()
TIMEDIFF()
*
TIMESTAMP()
TIMESTAMPADD()
TIMESTAMPDIFF()
TO_BASE64()
TO_DAYS()
TO_SECONDS()
TRIM()
TRUNCATE()
UCASE()
UpdateXML()
UPPER()
USER()
UTC_DATE()
UTC_TIME()
UTC_TIMESTAMP()
VALUES()
VERSION()
WEEK()
WEEKDAY()
WEEKOFYEAR()
WEIGHT_STRING()
XOR Logical XOR
YEAR() Return the year
YEARWEEK()