Логотип 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 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
LOWER
Return a string with all characters written in lowercase
MySQL
LOWER(str)
Examples
MySQL
SELECT LOWER('Hello world')
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
Contact us
Terms of use
English