Function Index
Prev   Next

Function Index

ABS()

Section 22.3, “Adding New Functions to MySQL”
Section 8.2.4, “Function Name Parsing and Resolution”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

ABS(X)

Section 11.5.2, “Mathematical Functions”

ACOS(X)

Section 11.5.2, “Mathematical Functions”

ADDDATE()

Section 11.6, “Date and Time Functions”

ADDDATE(date,INTERVAL expr unit)

Section 11.6, “Date and Time Functions”

ADDDATE(expr,days)

Section 11.6, “Date and Time Functions”

ADDTIME()

Section 11.6, “Date and Time Functions”

ADDTIME(expr1,expr2)

Section 11.6, “Date and Time Functions”

AES_DECRYPT()

Section 11.11.2, “Encryption and Compression Functions”

AES_DECRYPT(crypt_str,key_str)

Section 11.11.2, “Encryption and Compression Functions”

AES_ENCRYPT()

Section 11.11.2, “Encryption and Compression Functions”

AES_ENCRYPT(str,key_str)

Section 11.11.2, “Encryption and Compression Functions”

ASCII()

Section 12.3.3, “HELP Syntax”
Section 11.4, “String Functions”

ASCII(str)

Section 11.4, “String Functions”

ASIN(X)

Section 11.5.2, “Mathematical Functions”

ATAN(X)

Section 11.5.2, “Mathematical Functions”

ATAN(Y,X)

Section 11.5.2, “Mathematical Functions”

ATAN2(Y,X)

Section 11.5.2, “Mathematical Functions”

AVG()

Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 10.1.2, “Overview of Date and Time Types”
Section 10.4.4, “The ENUM Type”
Section 10.4.5, “The SET Type”

AVG([DISTINCT] expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

Area()

Section 11.13.5.2, “Geometry Functions”

Area(mpoly)

Section 11.13.5.2.6, “MultiPolygon Functions”

Area(poly)

Section 11.13.5.2.5, “Polygon Functions”

AsBinary()

Section 11.13.4.5, “Fetching Spatial Data”

AsBinary(g)

Section 11.13.5.1, “Geometry Format Conversion Functions”

AsText()

Section 11.13.4.5, “Fetching Spatial Data”

AsText(g)

Section 11.13.5.1, “Geometry Format Conversion Functions”

AsWKB(g)

Section 11.13.5.1, “Geometry Format Conversion Functions”

AsWKT(g)

Section 11.13.5.1, “Geometry Format Conversion Functions”

BENCHMARK()

Section 11.11.3, “Information Functions”

BENCHMARK(10, (SELECT * FROM t))

Section 11.11.3, “Information Functions”

BENCHMARK(count,expr)

Section 11.11.3, “Information Functions”

BIN()

Section 8.1.5, “Bit-Field Values”

BIN(N)

Section 11.4, “String Functions”

BIT_AND(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

BIT_COUNT(N)

Section 11.11.1, “Bit Functions”

BIT_LENGTH(str)

Section 11.4, “String Functions”

BIT_OR(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

BIT_XOR(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

BdMPolyFromText(wkt,srid)

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

BdMPolyFromWKB(wkb,srid)

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

BdPolyFromText(wkt,srid)

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

BdPolyFromWKB(wkb,srid)

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

Boundary(g)

Section 11.13.5.2.1, “General Geometry Functions”

Buffer(g,d)

Section 11.13.5.3.2, “Spatial Operators”

CAST()

Section 9.1.8.2, “CONVERT() and CAST()”
Section 8.1.5, “Bit-Field Values”
Section 11.9, “Cast Functions and Operators”
Section 11.2.3, “Comparison Functions and Operators”
Section 11.6, “Date and Time Functions”
Section 10.3, “Date and Time Types”
Section 9.1.8.1, “Result Strings”
Section 11.2.2, “Type Conversion in Expression Evaluation”
Section 8.4, “User-Defined Variables”

CAST(... AS UNSIGNED)

Section 8.1.3, “Hexadecimal Values”

CAST(... COLLATE ...)

Section 9.1.8.2, “CONVERT() and CAST()”

CAST(...) COLLATE ...

Section 9.1.8.2, “CONVERT() and CAST()”

CAST(expr AS CHAR)

Section 11.9, “Cast Functions and Operators”

CAST(expr AS type)

Section 11.9, “Cast Functions and Operators”

CAST(str AS BINARY)

Section 9.1.6.3, “BINARY Operator”
Section 11.9, “Cast Functions and Operators”

CEIL()

Section 11.5.2, “Mathematical Functions”

CEIL(X)

Section 11.5.2, “Mathematical Functions”

CEILING()

Section 11.5.2, “Mathematical Functions”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

CEILING(3.7004397181411)

Section 18.2.3.1, “LINEAR HASH Partitioning”

CEILING(X)

Section 11.5.2, “Mathematical Functions”

CHAR()

Section 11.4, “String Functions”

CHAR(1,0)

Section 11.4, “String Functions”

CHAR(1,0,0)

Section 11.4, “String Functions”

CHAR(128 | key_num)

Section 11.11.2, “Encryption and Compression Functions”

CHAR(256)

Section 11.4, “String Functions”

CHAR(256*256)

Section 11.4, “String Functions”

CHAR(N)

Section 11.9, “Cast Functions and Operators”

CHAR(N,... [USING charset_name])

Section 11.4, “String Functions”

CHARACTER_LENGTH()

Section 11.4, “String Functions”

CHARACTER_LENGTH(str)

Section 11.4, “String Functions”

CHARSET()

Section 9.1.8.1, “Result Strings”

CHARSET(str)

Section 11.11.3, “Information Functions”

CHAR_LENGTH()

Section 11.4, “String Functions”

CHAR_LENGTH(str)

Section 11.4, “String Functions”

COALESCE(value,...)

Section 11.2.3, “Comparison Functions and Operators”

COERCIBILITY()

Section 9.1.6.5, “Special Cases Where Collation Determination Is Tricky”

COERCIBILITY(str)

Section 11.11.3, “Information Functions”

COLLATION()

Section 9.1.8.1, “Result Strings”

COLLATION(str)

Section 11.11.3, “Information Functions”

COMPRESS()

Section 11.11.2, “Encryption and Compression Functions”

COMPRESS(string_to_compress)

Section 11.11.2, “Encryption and Compression Functions”

CONCAT()

Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 9.1.8.1, “Result Strings”
Section 11.4, “String Functions”
Section 9.1.7, “String Repertoire”
Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”
Section 11.2.2, “Type Conversion in Expression Evaluation”
Section 11.10, “XML Functions”

CONCAT(p1.id, p1.tvab) + 0 AS tvid

Section 3.7.1, “Find All Nondistributed Twins”

CONCAT(str1,str2,...)

Section 11.4, “String Functions”

CONCAT_WS()

Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 11.4, “String Functions”

CONCAT_WS(separator,str1,str2,...)

Section 11.4, “String Functions”

CONNECTION_ID()

Section 11.11.3, “Information Functions”

CONV()

Section 11.5.2, “Mathematical Functions”
Section 9.1.8.1, “Result Strings”

CONV(N,10,16)

Section 11.4, “String Functions”

CONV(N,10,2)

Section 11.4, “String Functions”

CONV(N,10,8)

Section 11.5.2, “Mathematical Functions”

CONV(N,from_base,to_base)

Section 11.5.2, “Mathematical Functions”

CONVERT()

Section 9.1.8.2, “CONVERT() and CAST()”
Section 11.9, “Cast Functions and Operators”
Section 9.1.3.5, “Character String Literal Character Set and Collation”
Section 11.2.3, “Comparison Functions and Operators”
Section 11.11.4, “Miscellaneous Functions”

CONVERT(... USING ...)

Section 9.1.8.2, “CONVERT() and CAST()”
Section 11.9, “Cast Functions and Operators”

CONVERT(expr USING transcoding_name)

Section 11.9, “Cast Functions and Operators”

CONVERT(expr,type)

Section 11.9, “Cast Functions and Operators”

CONVERT(ucs2)

Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”

CONVERT_TZ()

Section 11.6, “Date and Time Functions”

CONVERT_TZ(...,...,@@session.time_zone)

Section 16.3.1.24, “Replication and Time Zones”

CONVERT_TZ(dt,from_tz,to_tz)

Section 11.6, “Date and Time Functions”

COS(X)

Section 11.5.2, “Mathematical Functions”

COT(X)

Section 11.5.2, “Mathematical Functions”

COUNT()

Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 3.3.4.8, “Counting Rows”
Section 18.1, “Overview of Partitioning in MySQL”
Section 19.5.3, “Updatable and Insertable Views”
Section 19.5.2, “View Processing Algorithms”

COUNT(*)

Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 3.3.4.8, “Counting Rows”

COUNT(DISTINCT ...)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

COUNT(DISTINCT expr,[expr...])

Section 11.12.1, “GROUP BY (Aggregate) Functions”

COUNT(DISTINCT)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

COUNT(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

CRC32(expr)

Section 11.5.2, “Mathematical Functions”

CURDATE()

Section 3.3.4.5, “Date Calculations”
Section 11.6, “Date and Time Functions”

CURRENT_DATE

Section 10.1.4, “Data Type Default Values”
Section 11.6, “Date and Time Functions”
Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”

CURRENT_DATE()

Section 11.6, “Date and Time Functions”

CURRENT_TIME

Section 11.6, “Date and Time Functions”
Section 10.3.2, “The TIME Type”

CURRENT_TIME()

Section 11.6, “Date and Time Functions”

CURRENT_TIMESTAMP

Section 10.3.1.1, “TIMESTAMP Properties”
Section 10.1.4, “Data Type Default Values”
Section 11.6, “Date and Time Functions”

CURRENT_TIMESTAMP()

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.6, “Date and Time Functions”

CURRENT_USER

Section 11.11.3, “Information Functions”
Section 16.3.1.10, “Replication and System Functions”

CURRENT_USER()

Section 5.5.9, “Auditing MySQL Account Activity”
Section 11.11.3, “Information Functions”
Section 16.3.1.10, “Replication and System Functions”
Section 9.1.10, “UTF-8 for Metadata”

CURTIME()

Section 11.6, “Date and Time Functions”
Section 9.7, “MySQL Server Time Zone Support”

Centroid(mpoly)

Section 11.13.5.2.6, “MultiPolygon Functions”

Contains()

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

Contains(g1,g2)

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

ConvexHull(g)

Section 11.13.5.3.2, “Spatial Operators”

Create_func_abs

Section 22.3.3, “Adding a New Native Function”

Create_func_arg0

Section 22.3.3, “Adding a New Native Function”

Create_func_arg1

Section 22.3.3, “Adding a New Native Function”

Create_func_arg2

Section 22.3.3, “Adding a New Native Function”

Create_func_arg3

Section 22.3.3, “Adding a New Native Function”

Create_func_concat

Section 22.3.3, “Adding a New Native Function”

Create_func_lcase

Section 22.3.3, “Adding a New Native Function”

Create_func_lpad

Section 22.3.3, “Adding a New Native Function”

Create_func_pow

Section 22.3.3, “Adding a New Native Function”

Create_func_uuid

Section 22.3.3, “Adding a New Native Function”

Create_native_func

Section 22.3.3, “Adding a New Native Function”

Crosses(g1,g2)

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

DATABASE()

Section 3.4, “Getting Information About Databases and Tables”
Section 11.11.3, “Information Functions”
Section 9.1.10, “UTF-8 for Metadata”

DATE(expr)

Section 11.6, “Date and Time Functions”

DATEDIFF()

Section 11.6, “Date and Time Functions”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

DATEDIFF(expr1,expr2)

Section 11.6, “Date and Time Functions”

DATE_ADD()

Section 3.3.4.5, “Date Calculations”
Section 11.6, “Date and Time Functions”
Section 10.3, “Date and Time Types”

DATE_ADD(date,INTERVAL expr unit)

Section 11.6, “Date and Time Functions”

DATE_FORMAT()

Section 21.10.13, “C API Prepared Statement Problems”
Section 11.6, “Date and Time Functions”
Section 9.8, “MySQL Server Locale Support”

DATE_FORMAT(date,format)

Section 11.6, “Date and Time Functions”

DATE_SUB()

Section 11.6, “Date and Time Functions”
Section 10.3, “Date and Time Types”

DATE_SUB(date,INTERVAL expr unit)

Section 11.6, “Date and Time Functions”

DAY()

Section 11.6, “Date and Time Functions”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

DAY(date)

Section 11.6, “Date and Time Functions”

DAYNAME()

Section 9.8, “MySQL Server Locale Support”

DAYNAME(date)

Section 11.6, “Date and Time Functions”

DAYOFMONTH()

Section 3.3.4.5, “Date Calculations”
Section 11.6, “Date and Time Functions”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

DAYOFMONTH(date)

Section 11.6, “Date and Time Functions”

DAYOFWEEK()

Section 18.5.3, “Partitioning Limitations Relating to Functions”

DAYOFWEEK(date)

Section 11.6, “Date and Time Functions”

DAYOFYEAR()

Section 18.2, “Partition Types”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

DAYOFYEAR(date)

Section 11.6, “Date and Time Functions”

DECODE()

Section 11.11.2, “Encryption and Compression Functions”

DECODE(crypt_str,pass_str)

Section 11.11.2, “Encryption and Compression Functions”

DEFAULT(col_name)

Section 11.11.4, “Miscellaneous Functions”

DEFAULT(i)

Section 10.1.4, “Data Type Default Values”

DEGREES(X)

Section 11.5.2, “Mathematical Functions”

DES_DECRYPT()

Section 11.11.2, “Encryption and Compression Functions”

DES_DECRYPT(crypt_str[,key_str])

Section 11.11.2, “Encryption and Compression Functions”

DES_ENCRYPT()

Section 11.11.2, “Encryption and Compression Functions”

DES_ENCRYPT(str[,{key_num|key_str}])

Section 11.11.2, “Encryption and Compression Functions”

Difference(g1,g2)

Section 11.13.5.3.2, “Spatial Operators”

Dimension(g)

Section 11.13.5.2.1, “General Geometry Functions”

Disjoint(g1,g2)

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

Distance()

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

Distance(g1,g2)

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

ELT()

Section 9.1.8.1, “Result Strings”
Section 11.4, “String Functions”

ELT(N,str1,str2,str3,...)

Section 11.4, “String Functions”

ENCODE()

Section 11.11.2, “Encryption and Compression Functions”

ENCODE(str,pass_str)

Section 11.11.2, “Encryption and Compression Functions”

ENCRYPT()

Section 11.11.2, “Encryption and Compression Functions”
Section 5.5.1, “User Names and Passwords”

ENCRYPT(str[,salt])

Section 11.11.2, “Encryption and Compression Functions”

EXP()

Section 11.5.2, “Mathematical Functions”

EXP(X)

Section 11.5.2, “Mathematical Functions”

EXPORT_SET(bits,on,off[,separator[,number_of_bits]])

Section 11.4, “String Functions”

EXTRACT()

Section 11.9, “Cast Functions and Operators”
Section 11.6, “Date and Time Functions”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

EXTRACT(unit FROM date)

Section 11.6, “Date and Time Functions”

EndPoint()

Section 11.13.5.2.3, “LineString Functions”
Section 11.13.5.2.4, “MultiLineString Functions”

EndPoint(ls)

Section 11.13.5.2.3, “LineString Functions”
Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”

Envelope(g)

Section 11.13.5.2.1, “General Geometry Functions”
Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”

Equals(g1,g2)

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

ExteriorRing(poly)

Section 11.13.5.2.5, “Polygon Functions”
Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”

ExtractValue('<a><b>Sakila</b></a>', '/a/b')

Section 11.10, “XML Functions”

ExtractValue('<a><b>Sakila</b></a>', '/a/b/text()')

Section 11.10, “XML Functions”

ExtractValue()

Section 11.10, “XML Functions”

ExtractValue(xml_frag, xpath_expr)

Section 11.10, “XML Functions”

FIELD()

Section 11.4, “String Functions”

FIELD(str,str1,str2,str3,...)

Section 11.4, “String Functions”

FIND_IN_SET()

Section 11.4, “String Functions”
Section 10.4.5, “The SET Type”

FIND_IN_SET(str,strlist)

Section 11.4, “String Functions”

FLOOR()

Section 11.5.1, “Arithmetic Operators”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

FLOOR(X)

Section 11.5.2, “Mathematical Functions”

FLOOR(i RAND() * (j i))

Section 11.5.2, “Mathematical Functions”

FORMAT()

Section 9.1.8.1, “Result Strings”

FORMAT(X,D)

Section 11.5.2, “Mathematical Functions”
Section 11.11.4, “Miscellaneous Functions”
Section 11.4, “String Functions”

FOUND_ROWS()

Section 11.11.3, “Information Functions”
Section 16.3.1.10, “Replication and System Functions”

FROM_DAYS()

Section 11.6, “Date and Time Functions”

FROM_DAYS(N)

Section 11.6, “Date and Time Functions”

FROM_UNIXTIME()

Section 11.6, “Date and Time Functions”
Section 16.3.1.24, “Replication and Time Zones”

FROM_UNIXTIME(unix_timestamp)

Section 11.6, “Date and Time Functions”

FROM_UNIXTIME(unix_timestamp,format)

Section 11.6, “Date and Time Functions”

GET_FORMAT()

Section 11.6, “Date and Time Functions”
Section 9.8, “MySQL Server Locale Support”

GET_FORMAT(DATE,'EUR')

Section 11.6, “Date and Time Functions”

GET_FORMAT(DATE,'INTERNAL')

Section 11.6, “Date and Time Functions”

GET_FORMAT(DATE,'ISO')

Section 11.6, “Date and Time Functions”

GET_FORMAT(DATE,'JIS')

Section 11.6, “Date and Time Functions”

GET_FORMAT(DATE,'USA')

Section 11.6, “Date and Time Functions”

GET_FORMAT(DATETIME,'EUR')

Section 11.6, “Date and Time Functions”

GET_FORMAT(DATETIME,'INTERNAL')

Section 11.6, “Date and Time Functions”

GET_FORMAT(DATETIME,'ISO')

Section 11.6, “Date and Time Functions”

GET_FORMAT(DATETIME,'JIS')

Section 11.6, “Date and Time Functions”

GET_FORMAT(DATETIME,'USA')

Section 11.6, “Date and Time Functions”

GET_FORMAT(TIME,'EUR')

Section 11.6, “Date and Time Functions”

GET_FORMAT(TIME,'INTERNAL')

Section 11.6, “Date and Time Functions”

GET_FORMAT(TIME,'ISO')

Section 11.6, “Date and Time Functions”

GET_FORMAT(TIME,'JIS')

Section 11.6, “Date and Time Functions”

GET_FORMAT(TIME,'USA')

Section 11.6, “Date and Time Functions”

GET_FORMAT({DATE|TIME|DATETIME}, {'EUR'|'USA'|'JIS'|'ISO'|'INTERNAL'})

Section 11.6, “Date and Time Functions”

GET_LOCK()

Section 21.10.3.3, “mysql_change_user()”
Section 21.10.11, “Controlling Automatic Reconnection Behavior”
Section 11.11.4, “Miscellaneous Functions”
Section 16.3.1.10, “Replication and System Functions”

GET_LOCK(str,timeout)

Section 11.11.4, “Miscellaneous Functions”

GLength()

Section 11.13.5.2.3, “LineString Functions”
Section 11.13.5.2.4, “MultiLineString Functions”
Section 11.13.7, “MySQL Conformance and Compatibility”

GLength(ls)

Section 11.13.5.2.3, “LineString Functions”

GLength(mls)

Section 11.13.5.2.4, “MultiLineString Functions”

GREATEST()

Section 11.2.3, “Comparison Functions and Operators”
Section 9.1.8.1, “Result Strings”

GREATEST(value1,value2,...)

Section 11.2.3, “Comparison Functions and Operators”

GROUP_CONCAT(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

GeomCollFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

GeomCollFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

GeomFromText()

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
Section 11.13.4.4, “Populating Spatial Columns”

GeomFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
Section 11.13.5.1, “Geometry Format Conversion Functions”

GeomFromWKB()

Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

GeomFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
Section 11.13.5.1, “Geometry Format Conversion Functions”

GeometryCollection(g1,g2,...)

Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

GeometryCollectionFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

GeometryCollectionFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

GeometryFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

GeometryFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

GeometryN(gc,N)

Section 11.13.5.2.7, “GeometryCollection Functions”
Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”

GeometryType(g)

Section 11.13.5.2.1, “General Geometry Functions”

HEX()

Section 9.1.3.5, “Character String Literal Character Set and Collation”
Section 8.1.3, “Hexadecimal Values”
Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section 9.1.8.1, “Result Strings”

HEX(N_or_S)

Section 11.5.2, “Mathematical Functions”
Section 11.4, “String Functions”

HEX(str)

Section 11.4, “String Functions”

HOUR()

Section 18.5.3, “Partitioning Limitations Relating to Functions”

HOUR(time)

Section 11.6, “Date and Time Functions”

IF()

Section 11.3, “Control Flow Functions”
Section 9.1.8.1, “Result Strings”

IF(expr1,expr2,expr3)

Section 11.3, “Control Flow Functions”

IFNULL()

Section 11.3, “Control Flow Functions”

IFNULL(expr1,expr2)

Section 11.3, “Control Flow Functions”

IN()

Section 11.2.2, “Type Conversion in Expression Evaluation”

IN(value_list)

Section D.3, “Restrictions on Subqueries”

INET_ATON()

Section 11.11.4, “Miscellaneous Functions”

INET_ATON(expr)

Section 11.11.4, “Miscellaneous Functions”

INET_NTOA(expr)

Section 11.11.4, “Miscellaneous Functions”

INSERT(str,pos,len,newstr)

Section 11.4, “String Functions”

INSTR()

Section 9.1.8.1, “Result Strings”

INSTR(str,substr)

Section 11.4, “String Functions”

INTERVAL(N,N1,N2,N3,...)

Section 11.2.3, “Comparison Functions and Operators”

ISNULL()

Section 11.2.3, “Comparison Functions and Operators”

ISNULL(expr)

Section 11.2.3, “Comparison Functions and Operators”

IS_FREE_LOCK()

Section 16.3.1.10, “Replication and System Functions”

IS_FREE_LOCK(str)

Section 11.11.4, “Miscellaneous Functions”

IS_USED_LOCK()

Section 16.3.1.10, “Replication and System Functions”

IS_USED_LOCK(str)

Section 11.11.4, “Miscellaneous Functions”

InteriorRingN(poly,N)

Section 11.13.5.2.5, “Polygon Functions”
Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”

Intersection(g1,g2)

Section 11.13.5.3.2, “Spatial Operators”

Intersects(g1,g2)

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

IsClosed(mls)

Section 11.13.5.2.4, “MultiLineString Functions”

IsEmpty(g)

Section 11.13.5.2.1, “General Geometry Functions”

IsRing(ls)

Section 11.13.5.2.3, “LineString Functions”

IsSimple()

Section 11.13.5.2.1, “General Geometry Functions”

IsSimple(g)

Section 11.13.5.2.1, “General Geometry Functions”

LAST_DAY(date)

Section 11.6, “Date and Time Functions”

LAST_INSERT_ID()

Section 4.6.7.1, “mysqlbinlog Hex Dump Format”
Section 21.10.3.37, “mysql_insert_id()”
Section 21.10.11, “Controlling Automatic Reconnection Behavior”
Section 21.10.10.3, “How to Get the Unique ID for the Last Inserted Row”
Section 11.11.3, “Information Functions”
Section 16.3.1.1, “Replication and AUTO_INCREMENT”
Section 19.2.4, “Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()”
Section 16.3.5, “Troubleshooting Replication”
Section 19.5.3, “Updatable and Insertable Views”
Section 3.6.9, “Using AUTO_INCREMENT”

LAST_INSERT_ID(expr)

Section 21.10.3.37, “mysql_insert_id()”
Section 21.10.7.16, “mysql_stmt_insert_id()”
Section 11.11.3, “Information Functions”

LCASE()

Section 9.1.8.1, “Result Strings”
Section 11.4, “String Functions”

LCASE(str)

Section 11.4, “String Functions”

LEAST()

Section 11.2.3, “Comparison Functions and Operators”
Section 9.1.8.1, “Result Strings”

LEAST(value1,value2,...)

Section 11.2.3, “Comparison Functions and Operators”

LEFT()

Section 11.9, “Cast Functions and Operators”

LEFT(str,len)

Section 11.4, “String Functions”

LENGTH()

Section 11.4, “String Functions”

LENGTH(str)

Section 11.4, “String Functions”

LN()

Section 11.5.2, “Mathematical Functions”

LN(X)

Section 11.5.2, “Mathematical Functions”

LOAD_FILE()

Section 16.3.1.10, “Replication and System Functions”
Section 5.3.3, “Security-Related mysqld Options”

LOAD_FILE(file_name)

Section 11.4, “String Functions”

LOCALTIME

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.6, “Date and Time Functions”

LOCALTIME()

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.6, “Date and Time Functions”

LOCALTIMESTAMP

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.6, “Date and Time Functions”

LOCALTIMESTAMP()

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.6, “Date and Time Functions”

LOCATE()

Section 11.4, “String Functions”

LOCATE(substr,str)

Section 11.4, “String Functions”

LOCATE(substr,str,pos)

Section 11.4, “String Functions”

LOG()

Section 11.5.2, “Mathematical Functions”

LOG(10,X)

Section 11.5.2, “Mathematical Functions”

LOG(2,13)

Section 18.2.3.1, “LINEAR HASH Partitioning”

LOG(B,X)

Section 11.5.2, “Mathematical Functions”

LOG(X)

Section 11.5.2, “Mathematical Functions”

LOG(X) / LOG(2)

Section 11.5.2, “Mathematical Functions”

LOG(X) / LOG(B)

Section 11.5.2, “Mathematical Functions”

LOG10(X)

Section 11.5.2, “Mathematical Functions”

LOG2()

Section 11.5.2, “Mathematical Functions”

LOG2(X)

Section 11.5.2, “Mathematical Functions”

LOWER()

Section 9.1.8.1, “Result Strings”
Section 11.4, “String Functions”

LOWER(str)

Section 11.4, “String Functions”

LPAD(str,len,padstr)

Section 11.4, “String Functions”

LTRIM()

Section 9.1.8.1, “Result Strings”

LTRIM(str)

Section 11.4, “String Functions”

Length()

Section 11.13.5.2.3, “LineString Functions”
Section 11.13.5.2.4, “MultiLineString Functions”
Section 11.13.7, “MySQL Conformance and Compatibility”

LineFromText()

Section 11.13.5.1, “Geometry Format Conversion Functions”

LineFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

LineFromWKB()

Section 11.13.5.1, “Geometry Format Conversion Functions”

LineFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

LineString(pt1,pt2,...)

Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

LineStringFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

LineStringFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

MAKEDATE(year,dayofyear)

Section 11.6, “Date and Time Functions”

MAKETIME(hour,minute,second)

Section 11.6, “Date and Time Functions”

MAKE_SET(bits,str1,str2,...)

Section 11.4, “String Functions”

MASTER_POS_WAIT()

Section 12.6.2.4, “MASTER_POS_WAIT() Syntax”
Section 11.11.4, “Miscellaneous Functions”
Section 16.3.4, “Replication FAQ”

MASTER_POS_WAIT(log_name,log_pos[,timeout])

Section 11.11.4, “Miscellaneous Functions”

MATCH (col1,col2,...) AGAINST (expr [search_modifier])

Section 11.8, “Full-Text Search Functions”

MATCH()

Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”
Section 11.8.5, “Full-Text Restrictions”
Section 11.8, “Full-Text Search Functions”
Section 11.8.1, “Natural Language Full-Text Searches”

MATCH() ... AGAINST

Section 11.8, “Full-Text Search Functions”

MATCH() ... AGAINST()

Section 11.8.2, “Boolean Full-Text Searches”

MAX()

Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”
Section 19.5.3, “Updatable and Insertable Views”
Section 19.5.2, “View Processing Algorithms”
Section 10.3.4, “Year 2000 Issues and Date Types”

MAX([DISTINCT] expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

MAX(auto_increment_column) + 1 WHERE prefix=given-prefix

Section 3.6.9, “Using AUTO_INCREMENT”

MAX(col_name)

Section 10.1.1, “Overview of Numeric Types”

MBRContains()

Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”
Section 11.13.6.2, “Using a Spatial Index”

MBRContains(g1,g2)

Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”

MBRDisjoint(g1,g2)

Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”

MBREqual(g1,g2)

Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”

MBRIntersects(g1,g2)

Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”

MBROverlaps(g1,g2)

Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”

MBRTouches(g1,g2)

Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”

MBRWithin()

Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”
Section 11.13.6.2, “Using a Spatial Index”

MBRWithin(g1,g2)

Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”

MD5()

Section 18.2.4, “KEY Partitioning”
Section 8.2, “Schema Object Names”
Section 11.11.2, “Encryption and Compression Functions”
Section 5.3.1, “General Security Guidelines”
Section 5.5.6.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”

MD5(str)

Section 11.11.2, “Encryption and Compression Functions”

MICROSECOND()

Section 18.5.3, “Partitioning Limitations Relating to Functions”

MICROSECOND(expr)

Section 11.6, “Date and Time Functions”

MID()

Section 9.1.8.1, “Result Strings”

MID(str,pos,len)

Section 11.4, “String Functions”

MIN()

Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”
Section 19.5.3, “Updatable and Insertable Views”
Section 19.5.2, “View Processing Algorithms”
Section 10.3.4, “Year 2000 Issues and Date Types”

MIN([DISTINCT] expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

MIN(col_name)

Section 10.1.1, “Overview of Numeric Types”

MIN(number-with-zerofill)

Section 21.10.13, “C API Prepared Statement Problems”

MINUTE()

Section 18.5.3, “Partitioning Limitations Relating to Functions”

MINUTE(time)

Section 11.6, “Date and Time Functions”

MLineFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

MLineFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

MOD()

Section 11.5.1, “Arithmetic Operators”
Section 3.3.4.5, “Date Calculations”
Section 11.5.2, “Mathematical Functions”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

MOD(N,0)

Section 11.5.2, “Mathematical Functions”

MOD(N,M)

Section 11.5.2, “Mathematical Functions”

MOD(something,12)

Section 3.3.4.5, “Date Calculations”

MONTH()

Section 3.3.4.5, “Date Calculations”
Section 18.2, “Partition Types”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

MONTH(birth)

Section 3.3.4.5, “Date Calculations”

MONTH(date)

Section 11.6, “Date and Time Functions”

MONTHNAME()

Section 9.8, “MySQL Server Locale Support”

MONTHNAME(date)

Section 11.6, “Date and Time Functions”

MPointFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

MPointFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

MPolyFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

MPolyFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

MultiLineString(ls1,ls2,...)

Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

MultiLineStringFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

MultiLineStringFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

MultiPoint(pt1,pt2,...)

Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

MultiPointFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

MultiPointFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

MultiPolygon(poly1,poly2,...)

Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

MultiPolygonFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

MultiPolygonFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

NAME_CONST()

Section 19.6, “Binary Logging of Stored Programs”
Section 11.11.4, “Miscellaneous Functions”

NAME_CONST(name,value)

Section 11.11.4, “Miscellaneous Functions”

NOW()

Section 10.3.1.1, “TIMESTAMP Properties”
Section 10.1.4, “Data Type Default Values”
Section 11.6, “Date and Time Functions”
Section A.1, “MySQL 5.1 FAQ — General”
Section 9.7, “MySQL Server Time Zone Support”
Section 16.3.1.10, “Replication and System Functions”
Section 16.3.1.24, “Replication and Time Zones”
Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”
Section 10.3.3, “The YEAR Type”
Section 9.7.2, “Time Zone Leap Second Support”

NULLIF(expr1,expr2)

Section 11.3, “Control Flow Functions”

NumGeometries(gc)

Section 11.13.5.2.7, “GeometryCollection Functions”

NumInteriorRings(poly)

Section 11.13.5.2.5, “Polygon Functions”

NumPoints(ls)

Section 11.13.5.2.3, “LineString Functions”

OCT(N)

Section 11.5.2, “Mathematical Functions”

OCTET_LENGTH()

Section 11.4, “String Functions”

OCTET_LENGTH(str)

Section 11.4, “String Functions”

OLD_PASSWORD()

Section 11.11.2, “Encryption and Compression Functions”
Section 5.5.6.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
Section 5.5.6.3, “Password Hashing in MySQL”

OLD_PASSWORD(str)

Section 11.11.2, “Encryption and Compression Functions”

ORD()

Section 11.4, “String Functions”

ORD(str)

Section 11.4, “String Functions”

Overlaps(g1,g2)

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

PASSWORD()

Section 18.2.4, “KEY Partitioning”
Section 5.5.2, “Adding User Accounts”
Section 5.5.5, “Assigning Account Passwords”
Section 11.11.2, “Encryption and Compression Functions”
Section 5.5.6.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
Section 5.5.6.3, “Password Hashing in MySQL”
Section 5.5.1, “User Names and Passwords”

PASSWORD(str)

Section 11.11.2, “Encryption and Compression Functions”

PERIOD_ADD(P,N)

Section 11.6, “Date and Time Functions”

PERIOD_DIFF(P1,P2)

Section 11.6, “Date and Time Functions”

PI()

Section 8.2.4, “Function Name Parsing and Resolution”
Section 11.5.2, “Mathematical Functions”

POSITION(substr IN str)

Section 11.4, “String Functions”

POW()

Section 11.5.2, “Mathematical Functions”

POW(5-int_col,3) + 6

Section 18.2.3, “HASH Partitioning”

POW(X,Y)

Section 11.5.2, “Mathematical Functions”

POWER(2,4)

Section 18.2.3.1, “LINEAR HASH Partitioning”

POWER(X,Y)

Section 11.5.2, “Mathematical Functions”

Point()

Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

Point(x,y)

Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

PointFromText()

Section 11.13.5.1, “Geometry Format Conversion Functions”

PointFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

PointFromWKB()

Section 11.13.5.1, “Geometry Format Conversion Functions”

PointFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

PointN(ls,N)

Section 11.13.5.2.3, “LineString Functions”
Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”

PolyFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

PolyFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

Polygon(ls1,ls2,...)

Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

PolygonFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

PolygonFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

QUARTER()

Section 18.5.3, “Partitioning Limitations Relating to Functions”

QUARTER(date)

Section 11.6, “Date and Time Functions”

QUOTE(str)

Section 11.4, “String Functions”

RADIANS(X)

Section 11.5.2, “Mathematical Functions”

RAND()

Section 4.6.7.1, “mysqlbinlog Hex Dump Format”
Section 11.5.2, “Mathematical Functions”
Section 16.3.1.10, “Replication and System Functions”

RAND(N)

Section 11.5.2, “Mathematical Functions”

RELEASE_LOCK()

Section 11.11.4, “Miscellaneous Functions”
Section 16.3.1.10, “Replication and System Functions”

RELEASE_LOCK(str)

Section 11.11.4, “Miscellaneous Functions”

REPEAT()

Section 9.1.8.1, “Result Strings”

REPEAT(str,count)

Section 11.4, “String Functions”

REPLACE()

Section 9.1.8.1, “Result Strings”
Section 11.4, “String Functions”

REPLACE(str,from_str,to_str)

Section 11.4, “String Functions”

REVERSE()

Section 9.1.8.1, “Result Strings”

REVERSE(str)

Section 11.4, “String Functions”

RIGHT()

Section 3.3.4.5, “Date Calculations”
Section 9.1.8.1, “Result Strings”

RIGHT(str,len)

Section 11.4, “String Functions”

ROUND()

Section 11.5.2, “Mathematical Functions”

ROUND(X)

Section 11.5.2, “Mathematical Functions”

ROUND(X,D)

Section 11.5.2, “Mathematical Functions”

ROW_COUNT()

Section 21.10.3.1, “mysql_affected_rows()”
Section 11.11.3, “Information Functions”
Section 16.3.1.10, “Replication and System Functions”

RPAD()

Section 9.1.8.1, “Result Strings”

RPAD(str,len,padstr)

Section 11.4, “String Functions”

RTRIM()

Section 9.1.8.1, “Result Strings”

RTRIM(str)

Section 11.4, “String Functions”

Related()

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

SCHEMA()

Section 11.11.3, “Information Functions”

SECOND()

Section 18.5.3, “Partitioning Limitations Relating to Functions”

SECOND(time)

Section 11.6, “Date and Time Functions”

SEC_TO_TIME(seconds)

Section 11.6, “Date and Time Functions”

SESSION_USER()

Section 11.11.3, “Information Functions”
Section 9.1.10, “UTF-8 for Metadata”

SHA()

Section 11.11.2, “Encryption and Compression Functions”

SHA(str)

Section 11.11.2, “Encryption and Compression Functions”

SHA1()

Section 11.11.2, “Encryption and Compression Functions”
Section 5.3.1, “General Security Guidelines”
Section 5.5.6.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”

SHA1(str)

Section 11.11.2, “Encryption and Compression Functions”

SIGN(X)

Section 11.5.2, “Mathematical Functions”

SIN(3.14)

Section 22.3.2.3, “UDF Argument Processing”

SIN(X)

Section 11.5.2, “Mathematical Functions”

SLEEP()

Section 11.11.4, “Miscellaneous Functions”
Section 16.3.1, “Replication Features and Issues”
Section D.7.3, “Windows Platform Limitations”

SLEEP(duration)

Section 11.11.4, “Miscellaneous Functions”

SOUNDEX()

Section 22.3, “Adding New Functions to MySQL”
Section 9.1.8.1, “Result Strings”
Section 11.4, “String Functions”

SOUNDEX(expr1) = SOUNDEX(expr2)

Section 11.4, “String Functions”

SOUNDEX(str)

Section 11.4, “String Functions”

SPACE()

Section 9.1.8.1, “Result Strings”

SPACE(N)

Section 11.4, “String Functions”

SQRT(X)

Section 11.5.2, “Mathematical Functions”

SRID(g)

Section 11.13.5.2.1, “General Geometry Functions”

STD()

Section 11.12.1, “GROUP BY (Aggregate) Functions”

STD(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

STDDEV()

Section 11.12.1, “GROUP BY (Aggregate) Functions”

STDDEV(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

STDDEV_POP()

Section 11.12.1, “GROUP BY (Aggregate) Functions”

STDDEV_POP(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

STDDEV_SAMP()

Section 11.12.1, “GROUP BY (Aggregate) Functions”

STDDEV_SAMP(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

STRCMP()

Section 11.4.1, “String Comparison Functions”

STRCMP(expr1,expr2)

Section 11.4.1, “String Comparison Functions”

STR_TO_DATE()

Section 11.6, “Date and Time Functions”
Section 9.8, “MySQL Server Locale Support”

STR_TO_DATE(str,format)

Section 11.6, “Date and Time Functions”

SUBDATE()

Section 11.6, “Date and Time Functions”

SUBDATE(date,INTERVAL expr unit)

Section 11.6, “Date and Time Functions”

SUBDATE(expr,days)

Section 11.6, “Date and Time Functions”

SUBSTR()

Section 11.4, “String Functions”

SUBSTR(str FROM pos FOR len)

Section 11.4, “String Functions”

SUBSTR(str FROM pos)

Section 11.4, “String Functions”

SUBSTR(str,pos)

Section 11.4, “String Functions”

SUBSTR(str,pos,len)

Section 11.4, “String Functions”

SUBSTRING()

Section 5.5.9, “Auditing MySQL Account Activity”
Section 9.1.8.1, “Result Strings”
Section 11.4, “String Functions”
Section 10.4.3, “The BLOB and TEXT Types”

SUBSTRING(str FROM pos FOR len)

Section 11.4, “String Functions”

SUBSTRING(str FROM pos)

Section 11.4, “String Functions”

SUBSTRING(str,pos)

Section 11.4, “String Functions”

SUBSTRING(str,pos,len)

Section 11.4, “String Functions”

SUBSTRING_INDEX()

Section 11.4, “String Functions”

SUBSTRING_INDEX(str,delim,count)

Section 11.4, “String Functions”

SUBTIME()

Section 11.6, “Date and Time Functions”

SUBTIME(expr1,expr2)

Section 11.6, “Date and Time Functions”

SUM()

Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 22.3.2, “Adding a New User-Defined Function”
Section 10.1.2, “Overview of Date and Time Types”
Section 18.1, “Overview of Partitioning in MySQL”
Section 10.4.4, “The ENUM Type”
Section 10.4.5, “The SET Type”
Section 19.5.3, “Updatable and Insertable Views”
Section 19.5.2, “View Processing Algorithms”

SUM([DISTINCT] expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

SYSDATE()

Section 11.6, “Date and Time Functions”
Section 16.3.1.10, “Replication and System Functions”

SYSTEM_USER()

Section 11.11.3, “Information Functions”
Section 9.1.10, “UTF-8 for Metadata”

StartPoint()

Section 11.13.5.2.3, “LineString Functions”
Section 11.13.5.2.4, “MultiLineString Functions”

StartPoint(ls)

Section 11.13.5.2.3, “LineString Functions”
Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”

SymDifference(g1,g2)

Section 11.13.5.3.2, “Spatial Operators”

TAN(X)

Section 11.5.2, “Mathematical Functions”

TIME(expr)

Section 11.6, “Date and Time Functions”

TIMEDIFF()

Section 11.6, “Date and Time Functions”

TIMEDIFF(expr1,expr2)

Section 11.6, “Date and Time Functions”

TIMESTAMP()

Section 11.6, “Date and Time Functions”

TIMESTAMP(expr)

Section 11.6, “Date and Time Functions”

TIMESTAMP(expr1,expr2)

Section 11.6, “Date and Time Functions”

TIMESTAMPADD()

Section 11.6, “Date and Time Functions”

TIMESTAMPADD(unit,interval,datetime_expr)

Section 11.6, “Date and Time Functions”

TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2)

Section 11.6, “Date and Time Functions”

TIME_FORMAT(time,format)

Section 11.6, “Date and Time Functions”

TIME_TO_SEC()

Section 18.5.3, “Partitioning Limitations Relating to Functions”

TIME_TO_SEC(time)

Section 11.6, “Date and Time Functions”

TO_DAYS()

Section 11.6, “Date and Time Functions”
Section 18.4, “Partition Pruning”
Section 18.2, “Partition Types”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

TO_DAYS(date)

Section 11.6, “Date and Time Functions”

TO_DAYS(date_col)

Section 18.2.3, “HASH Partitioning”

TRIM()

Section 9.1.8.1, “Result Strings”

TRIM([remstr FROM] str)

Section 11.4, “String Functions”

TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str)

Section 11.4, “String Functions”

TRUNCATE(X,D)

Section 11.5.2, “Mathematical Functions”

Touches(g1,g2)

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

UCASE()

Section 9.1.8.1, “Result Strings”
Section 11.4, “String Functions”

UCASE(str)

Section 11.4, “String Functions”

UNCOMPRESS()

Section 11.11.2, “Encryption and Compression Functions”

UNCOMPRESS(string_to_uncompress)

Section 11.11.2, “Encryption and Compression Functions”

UNCOMPRESSED_LENGTH(compressed_string)

Section 11.11.2, “Encryption and Compression Functions”

UNHEX()

Section 11.4, “String Functions”

UNHEX(str)

Section 11.4, “String Functions”

UNIX_TIMESTAMP()

Section 11.6, “Date and Time Functions”

UNIX_TIMESTAMP(date)

Section 11.6, “Date and Time Functions”

UPPER()

Section 9.1.8.1, “Result Strings”
Section 11.4, “String Functions”

UPPER(X)

Section 9.1.8.1, “Result Strings”

UPPER(_utf8'abc')

Section 9.1.7, “String Repertoire”

UPPER(str)

Section 11.4, “String Functions”

USER()

Section 5.5.9, “Auditing MySQL Account Activity”
Section 11.11.3, “Information Functions”
Section 16.3.1.10, “Replication and System Functions”
Section 9.1.6.5, “Special Cases Where Collation Determination Is Tricky”
Section 9.1.10, “UTF-8 for Metadata”

UTC_DATE

Section 11.6, “Date and Time Functions”

UTC_DATE()

Section 11.6, “Date and Time Functions”

UTC_TIME

Section 11.6, “Date and Time Functions”

UTC_TIME()

Section 11.6, “Date and Time Functions”

UTC_TIMESTAMP

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.6, “Date and Time Functions”

UTC_TIMESTAMP()

Section 11.6, “Date and Time Functions”
Section 9.7, “MySQL Server Time Zone Support”

UUID()

Section 19.6, “Binary Logging of Stored Programs”
Section 11.11.4, “Miscellaneous Functions”
Section 16.3.1.10, “Replication and System Functions”

UUID_SHORT()

Section 11.11.4, “Miscellaneous Functions”

Union(g1,g2)

Section 11.13.5.3.2, “Spatial Operators”

UpdateXML()

Section 11.10, “XML Functions”

UpdateXML(xml_target, xpath_expr, new_xml)

Section 11.10, “XML Functions”

VALUES()

Section 11.11.4, “Miscellaneous Functions”

VALUES(col_name)

Section 11.11.4, “Miscellaneous Functions”

VARIANCE()

Section 11.12.1, “GROUP BY (Aggregate) Functions”

VARIANCE(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

VAR_POP()

Section 11.12.1, “GROUP BY (Aggregate) Functions”

VAR_POP(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

VAR_SAMP()

Section 11.12.1, “GROUP BY (Aggregate) Functions”

VAR_SAMP(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

VERSION()

Section 11.11.3, “Information Functions”
Section 16.3.1.10, “Replication and System Functions”
Section 9.1.6.5, “Special Cases Where Collation Determination Is Tricky”
Section 9.1.10, “UTF-8 for Metadata”

WEEK()

Section 11.6, “Date and Time Functions”

WEEK(date,3)

Section 11.6, “Date and Time Functions”

WEEK(date[,mode])

Section 11.6, “Date and Time Functions”

WEEKDAY()

Section 18.2, “Partition Types”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

WEEKDAY(date)

Section 11.6, “Date and Time Functions”

WEEKOFYEAR()

Section 11.6, “Date and Time Functions”

WEEKOFYEAR(date)

Section 11.6, “Date and Time Functions”

Within()

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

Within(g1,g2)

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

X(p)

Section 11.13.5.2.2, “Point Functions”

Y(p)

Section 11.13.5.2.2, “Point Functions”

YEAR('1984-06-21')

Section 18.4, “Partition Pruning”

YEAR('1999-06-21')

Section 18.4, “Partition Pruning”

YEAR()

Section 3.3.4.5, “Date Calculations”
Section 18.4, “Partition Pruning”
Section 18.2, “Partition Types”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

YEAR(NULL)

Section 18.2.6, “How MySQL Partitioning Handles NULL”

YEAR(date)

Section 11.6, “Date and Time Functions”

YEAR(date_col)

Section 18.2.3, “HASH Partitioning”

YEAR(dob)

Section 18.3.1, “Management of RANGE and LIST Partitions”

YEAR(separated)

Section 18.2.1, “RANGE Partitioning”

YEARWEEK()

Section 11.6, “Date and Time Functions”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

YEARWEEK(date)

Section 11.6, “Date and Time Functions”

YEARWEEK(date,mode)

Section 11.6, “Date and Time Functions”

addslashes()

Section 5.3.1, “General Security Guidelines”

ascii

Section 9.1.7, “String Repertoire”
Section 9.1.12.2, “West European Character Sets”

binary

Section 9.4, “Adding a New Character Set”
Section 21.10.1, “C API Data Types”
Section 21.10.5, “C API Prepared Statement Data types”
Section 9.1.4, “Connection Character Sets and Collations”
Description
Section 9.1.8.1, “Result Strings”
Section 9.1.6.4, “The _bin and binary Collations”

case

Section 9.4, “Adding a New Character Set”

char

Section 21.10.5, “C API Prepared Statement Data types”
Section 13.9, “The MEMORY (HEAP) Storage Engine”

charset

Section 4.5.1.2, “mysql Commands”
Section 9.1.4, “Connection Character Sets and Collations”

collation

Section 9.4.1, “The Character Definition Arrays”

compress

Section 21.10.3.49, “mysql_options()”

count

Section 8.2.4, “Function Name Parsing and Resolution”

crypt()

Section 11.11.2, “Encryption and Compression Functions”

date

Section 11.6, “Date and Time Functions”

day

Section 21.10.5, “C API Prepared Statement Data types”

expr IN (value,...)

Section 11.2.3, “Comparison Functions and Operators”

expr NOT IN (value,...)

Section 11.2.3, “Comparison Functions and Operators”

hour

Section 21.10.5, “C API Prepared Statement Data types”

length

Section 21.10.3.34, “mysql_hex_string()”
Section 21.10.3.53, “mysql_real_escape_string()”
Section 21.10.3.54, “mysql_real_query()”
Section 21.10.7.11, “mysql_stmt_fetch()”
Section 21.10.7.20, “mysql_stmt_prepare()”
Section 21.10.7.25, “mysql_stmt_send_long_data()”
Section 21.10.5, “C API Prepared Statement Data types”
Section 22.2.3.3, “Creating a Plugin Library”
Section 22.2.3.2, “Type-Specific Plugin Structures and Functions”

lower

Section 11.4.2, “Regular Expressions”
Section 9.4.1, “The Character Definition Arrays”

main()

Section 21.9, “libmysqld, the Embedded MySQL Server Library”

minute

Section 21.10.5, “C API Prepared Statement Data types”

month

Section 21.10.5, “C API Prepared Statement Data types”

mysql_add_word()

Section 22.2.3.2, “Type-Specific Plugin Structures and Functions”

mysql_escape_string()

Section 5.3.1, “General Security Guidelines”

mysql_library_xxx()

Section 21.9, “libmysqld, the Embedded MySQL Server Library”

mysql_parse()

Section 22.2.3.2, “Type-Specific Plugin Structures and Functions”

mysql_real_escape_string()

Section 5.3.1, “General Security Guidelines”

old-password

Description

or

Section 11.10, “XML Functions”

password

Description

pthread_exit()

Section 21.9, “libmysqld, the Embedded MySQL Server Library”

quote

Section 5.3.1, “General Security Guidelines”
Section 8.1.1, “Strings”

second

Section 21.10.5, “C API Prepared Statement Data types”

space

Section 11.4.2, “Regular Expressions”

upper

Section 11.4.2, “Regular Expressions”
Section 9.4.1, “The Character Definition Arrays”

user

Section 21.10.3.49, “mysql_options()”
Section 21.10.3.52, “mysql_real_connect()”
Section 5.5.2, “Adding User Accounts”
Section 5.5.5, “Assigning Account Passwords”
Section 5.5.9, “Auditing MySQL Account Activity”
Section 3.1, “Connecting to and Disconnecting from the Server”
Description
Section 11.11.2, “Encryption and Compression Functions”
Section 5.3.1, “General Security Guidelines”
Section 5.3.5, “How to Run MySQL as a Normal User”
Section 5.5.4, “Limiting Account Resources”
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 5.5.6.3, “Password Hashing in MySQL”
Section D.6, “Restrictions on Character Sets”
Section 5.5.1, “User Names and Passwords”
Section 5.5.7.2, “Using SSL Connections”
Section 11.10, “XML Functions”

version

Description
Section 22.2.3.1, “General Plugin Structures and Functions”

year

Section 11.12.2, “GROUP BY Modifiers”
Section 21.10.5, “C API Prepared Statement Data types”
Prev   Next
Command Index Home INFORMATION_SCHEMA Index