Логотип sql academy
CourseTrainer
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
LENGTH
Returns the length of the string
MySQL
LENGTH(str)
str
The string whose length is returned by the function
Examples
MySQL
SELECT LENGTH('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
Contact us
Terms of use
English