MySQL関数リファレンス
■ 文字列関数
CONCAT
LENGTY / OCAT_LENGTH
CHAR_LENGTH / CHARACTER_LENGTH
LOCATE / POSITION
INSTR
LEFT
RIGHT
SUBSTRING / SUBSTRING / MID
SUBSTRING / SUBSTRING
SUBSTRING_INDEX
REPLACE
INSERT
LCASE / LOWER
UCASE / UPPER
REVERSE
LTRIM
RTRIM
TRIM
LPAD
RPAD
SPACE
REPEAT
LOAD_FILE
ASCII
ORD
CHAR
CONV
BIN
OCT
HEX
■ 日付関数
CURDATE / CURRENT_DATE
CURTIME / CURRENT_TIME
NOW / SYSDATE / CURRENT_TIMESTAMP
UNIX_TIMESTAMP
DATE_FORMAT
FROM_UNIXTIME
SEC_TO_TIME
TIME_TO_SCALE
YEAR
MONTH
DAYOFMONTH
HOUR
MINUTE
SECOND
DAYOFWEEK
WEEKDAY
QUARTER
DAYOFYEAR
WEEK
DAYNAME
MONTHNAME
EXTRACT
DATE_ADD / DATE_SUB / ADDDATE / SUBDATE
PERIOD_ADD
TO_DAYS
FROM_DAYS
■ 数学関数
FORMAT
ROUND
ROUND
FLOOR
CEILING
TRUNCATE
ABS
MOD
POW / POWER
RAND
SIGN
COS
SIN
TAN
ACOS
ASIN
ASIN
ATAN
ATAN2
COT
EXP
LOG
LOG10
SQRT
PI
DEGRESS
RADIANS
■ 制御関数
IF
CASE
IFNULL
ISNULL
COALCASE
GREATEST
ELT
FIELD
INTERVAL
FIND_IN_SET
MAKE_SET
■ その他の関数
DATABASE
USER / SYSTEM_USER / SESSION_USER
VERSION
PASSWORD
ENCODE
DECODE
GETR_LOCK
RELEASE_LOCK