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
14
CEILING
FLOOR
ROUND
ABS
MOD
GREATEST
LEAST
RAND
POW
SQRT
SIGN
EXP
LOG
PI
Date and time functions
19
NOW
TIMESTAMPADD
TIMESTAMPDIFF
DATE_FORMAT
DATE
DATEDIFF
TIMEDIFF
ADDDATE
SUBDATE
YEAR
MONTH
DAY
HOUR
MINUTE
CURDATE
CURTIME
MONTHNAME
DAYNAME
DAYOFWEEK
Advanced functions
6
WITH
ISNULL
IF
COALESCE
IFNULL
NULLIF
RIGHT
Returns the specified number of rightmost characters of the string
MySQL
RIGHT
(
str
,
number_of_characters
)
str
Source string
number_of_characters
The number of characters to extract
Examples
MySQL
SELECT
RIGHT
(
'sql-academy'
,
3
)
;
String functions
18
LENGTH
SUBSTRING
REPLACE
LOCATE
LOWER
UPPER
REVERSE
TRIM
LPAD
RPAD
LTRIM
RTRIM
REPEAT
CONCAT
INSTR
LEFT
RIGHT
CHAR
Numeric functions
14
CEILING
FLOOR
ROUND
ABS
MOD
GREATEST
LEAST
RAND
POW
SQRT
SIGN
EXP
LOG
PI
Date and time functions
19
NOW
TIMESTAMPADD
TIMESTAMPDIFF
DATE_FORMAT
DATE
DATEDIFF
TIMEDIFF
ADDDATE
SUBDATE
YEAR
MONTH
DAY
HOUR
MINUTE
CURDATE
CURTIME
MONTHNAME
DAYNAME
DAYOFWEEK
Advanced functions
6
WITH
ISNULL
IF
COALESCE
IFNULL
NULLIF