Course
Trainer
More
Premium
Log in
String functions
18
LENGTH
SUBSTRING
REPLACE
LOCATE
LOWER
UPPER
REVERSE
TRIM
LPAD
RPAD
LTRIM
RTRIM
REPEAT
CONCAT
INSTR
LEFT
RIGHT
CHAR
Numeric functions
18
CEILING
FLOOR
ROUND
ABS
MOD
TRUNCATE
GREATEST
LEAST
RAND
POW
SQRT
SIGN
EXP
LOG
PI
SIN
COS
TAN
Date and time functions
20
NOW
TIMESTAMPADD
TIMESTAMPDIFF
DATE_FORMAT
DATE
DATEDIFF
TIMEDIFF
ADDDATE
SUBDATE
YEAR
MONTH
DAY
HOUR
MINUTE
CURDATE
CURTIME
STR_TO_DATE
MONTHNAME
DAYNAME
DAYOFWEEK
Advanced functions
7
WITH
ISNULL
IF
COALESCE
IFNULL
CAST
NULLIF
NULLIF
Returns NULL if the values passed by the 1st or 2nd argument match, otherwise returns the value passed by the first argument.
MySQL
NULLIF
(
value_1
,
value_2
)
Examples
MySQL
NULLIF
(
"SQL Academy"
,
"SQL Academy"
)
;
String functions
18
LENGTH
SUBSTRING
REPLACE
LOCATE
LOWER
UPPER
REVERSE
TRIM
LPAD
RPAD
LTRIM
RTRIM
REPEAT
CONCAT
INSTR
LEFT
RIGHT
CHAR
Numeric functions
18
CEILING
FLOOR
ROUND
ABS
MOD
TRUNCATE
GREATEST
LEAST
RAND
POW
SQRT
SIGN
EXP
LOG
PI
SIN
COS
TAN
Date and time functions
20
NOW
TIMESTAMPADD
TIMESTAMPDIFF
DATE_FORMAT
DATE
DATEDIFF
TIMEDIFF
ADDDATE
SUBDATE
YEAR
MONTH
DAY
HOUR
MINUTE
CURDATE
CURTIME
STR_TO_DATE
MONTHNAME
DAYNAME
DAYOFWEEK
Advanced functions
7
WITH
ISNULL
IF
COALESCE
IFNULL
CAST
NULLIF