MySQL Select function list

MySQL Select function list

There are quite a few functions which can be used in MySQL select statement.

Common Text Function:

LEFT()	Returns the leftmost number of characters as specified
LOCATE()	Returns the position of the first occurrence of substring
LOWER()	Returns the argument in lowercase
LTRIM()	Removes leading spaces
RIGHT()	Returns the specified rightmost number of characters
RTRIM()	Removes trailing spaces
TRIM()	Removes leading and trailing spaces
UPPER()	Converts to uppercase

Common Datetime Functions

ADDDATE()	Add time values (intervals) to a date value
ADDTIME()	Add time
CONVERT_TZ()	Convert from one timezone to another
CURDATE()	Return the current date
CURTIME()	Return the current time
DATE()	Extract the date part of a date or datetime expression
DATEDIFF()	Subtract two dates
DAYNAME()	Return the name of the weekday
DAYOFMONTH()	Return the day of the month (0-31)
DAYOFWEEK()	Return the weekday index of the argument
DAYOFYEAR()	Return the day of the year (1-366)
HOUR()	Extract the hour
MINUTE()	Return the minute from the argument
MONTH()	Return the month from the date passed
NOW()	Return the current date and time
SECOND()	Return the second (0-59)
YEAR()	Return the year

Aggregate functions:

AVG()	Average of the column
COUNT()	counter of the column
MAX()	Maximine of the column
MIN()	Minimen of the column
SUM()	summary of the column