functions関連一覧
- ABS(X)
- ACOS(X)
- ADDDATE(date,INTERVAL expr unit)
- ADDTIME(expr1,expr2)
- AES_ENCRYPT(str,key_str)
- ASCII(str)
- ASIN(X)
- ATAN(X)
- ATAN(Y,X)
- AVG([DISTINCT] expr)
- BENCHMARK(count,expr)
- BIN(N)
- BIT_AND(expr)
- BIT_LENGTH(str)
- BIT_OR(expr)
- BIT_XOR(expr)
- CAST(expr AS type)
- CEILING(X)
- CHAR(N,... [USING charset_name])
- CHAR_LENGTH(str)
- CHARACTER_LENGTH(str)
- CHARSET(str)
- COERCIBILITY(str)
- COLLATION(str)
- COMPRESS(string_to_compress)
- CONCAT(str1,str2,...)
- CONCAT_WS(separator,str1,str2,...)
- CONNECTION_ID()
- CONV(N,from_base,to_base)
- CONVERT_TZ(dt,from_tz,to_tz)
- COS(X)
- COT(X)
- COUNT(expr)
- COUNT(DISTINCT expr,[expr...])
- CRC32(expr)
- CURDATE()
- CURRENT_DATE
- CURRENT_TIME
- CURRENT_TIMESTAMP
- CURRENT_USER
- CURTIME()
- DATABASE()
- DATE(expr)
- DATE_ADD(date,INTERVAL expr unit)
- DATE_FORMAT(date,format)
- DATE_SUB(date,INTERVAL expr unit)
- DATEDIFF(expr1,expr2)
- DAY(date)
- DAYNAME(date)
- DAYOFMONTH(date)
- DAYOFWEEK(date)
- DAYOFYEAR(date)
- DECODE(crypt_str,pass_str)
- DEFAULT(col_name)
- DEGREES(X)
- DES_DECRYPT(crypt_str[,key_str])
- DES_ENCRYPT(str[,{key_num|key_str}])
- ELT(N,str1,str2,str3,...)
- ENCODE(str,pass_str)
- ENCRYPT(str[,salt])
- EXP(X)
- EXPORT_SET(bits,on,off[,separator[,number_of_bits]])
- EXTRACT(unit FROM date)
- ExtractValue(xml_frag, xpath_expr)
- FIELD(str,str1,str2,str3,...)
- FIND_IN_SET(str,strlist)
- FLOOR(X)
- FORMAT(X,D)
- FOUND_ROWS()
- FROM_DAYS(N)
- FROM_UNIXTIME(unix_timestamp)
- GET_FORMAT(DATE|TIME|DATETIME, 'EUR'|'USA'|'JIS'|'ISO'|'INTERNAL')
- GET_LOCK(str,timeout)
- GROUP_CONCAT(expr)
- HEX(N_or_S)
- HOUR(time)
- IF(expr1,expr2,expr3)
- IFNULL(expr1,expr2)
- INET_ATON(expr)
- INET_NTOA(expr)
- INSERT(str,pos,len,newstr)
- INSTR(str,substr)
- IS_FREE_LOCK(str)
- IS_USED_LOCK(str)
- LAST_DAY(date)
- LAST_INSERT_ID()
- LCASE(str)
- LEFT(str,len)
- LENGTH(str)
- LN(X)
- LOAD_FILE(file_name)
- LOCALTIME
- LOCALTIMESTAMP
- LOCATE(substr,str)
- LOG(X)
- LOG10(X)
- LOG2(X)
- LOWER(str)
- LPAD(str,len,padstr)
- LTRIM(str)
- MAKE_SET(bits,str1,str2,...)
- MAKEDATE(year,dayofyear)
- MAKETIME(hour,minute,second)
- MASTER_POS_WAIT(log_name,log_pos[,timeout])
- MD5(str)
- MICROSECOND(expr)
- MID(str,pos,len)
- MIN([DISTINCT] expr)
- MINUTE(time)
- MOD(N,M)
- MONTH(date)
- MONTHNAME(date)
- NAME_CONST(name,value)
- NOW()
- NULLIF(expr1,expr2)
- OCT(N)
- OCTET_LENGTH(str)
- OLD_PASSWORD(str)
- ORD(str)
- PASSWORD(str)
- PERIOD_ADD(P,N)
- PERIOD_DIFF(P1,P2)
- PI()
- POSITION(substr IN str)
- POW(X,Y)
- QUARTER(date)
- QUOTE(str)
- RADIANS(X)
- RAND()
- RELEASE_LOCK(str)
- REPEAT(str,count)
- REPLACE(str,from_str,to_str)
- REVERSE(str)
- RIGHT(str,len)
- ROUND(X)
- ROW_COUNT()
- RPAD(str,len,padstr)
- RTRIM(str)
- SCHEMA()
- SEC_TO_TIME(seconds)
- SECOND(time)
- SESSION_USER()
- SHA1(str)
- SIGN(X)
- SIN(X)
- SLEEP(duration)
- SOUNDEX(str)
- expr1 SOUNDS LIKE expr2
- SPACE(N)
- SQRT(X)
- STD(expr)
- STDDEV_POP(expr)
- STDDEV_SAMP(expr)
- STR_TO_DATE(str,format)
- STRCMP(expr1,expr2)
- SUBDATE(date,INTERVAL expr unit)
- SUBSTRING(str,pos)
- SUBSTRING_INDEX(str,delim,count)
- SUBTIME(expr1,expr2)
- SUM([DISTINCT] expr)
- SYSDATE()
- SYSTEM_USER()
- TAN(X)
- TIME(expr)
- TIME_FORMAT(time,format)
- TIME_TO_SEC(time)
- TIMEDIFF(expr1,expr2)
- TIMESTAMP(expr)
- TIMESTAMPADD(unit,interval,datetime_expr)
- TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2)
- TO_DAYS(date)
- TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str)
- TRUNCATE(X,D)
- UCASE(str)
- UNCOMPRESS(string_to_uncompress)
- UNCOMPRESSED_LENGTH(compressed_string)
- UNHEX(str)
- UNIX_TIMESTAMP()
- UpdateXML(xml_target, xpath_expr, new_xml)
- UPPER(str)
- USER()
- UTC_DATE
- UTC_TIME
- UTC_TIMESTAMP
- UUID()
- VALUES(col_name)
- VAR_POP(expr)
- VAR_SAMP(expr)
- VARIANCE(expr)
- VERSION()
- WEEK(date[,mode])
- WEEKDAY(date)
- WEEKOFYEAR(date)
- YEAR(date)
- YEARWEEK(date)
- BINARY
- CASE value WHEN [compare_value] THEN result [WHEN [compare_value] THEN result ...] [ELSE result] END
- expr LIKE pat [ESCAPE 'escape_char']
- expr NOT LIKE pat [ESCAPE 'escape_char']
- expr NOT REGEXP pat
- expr REGEXP pat