MySQL Functions

This is an alphabetical listing of our documentation of MySQL functions. This is provided as a quick way to get to the documentation page when you know which function you need information on. The more popular functions are highlighted with blue text for the heading.

ABS( )
This MySQL function returns the absolute value of a given number.
page views: 3,087;
category: Math Functions
This MySQL function returns a series of strings in order that represent each bit of a given number.
page views: 3,248;
category: String Functions
RADIANS( )
This MySQL function converts degrees to radians.
page views: 2,888;
category: Math Functions
ACOS( )
This MySQL function returns the arccosine, in radians, of a given number.
page views: 2,791;
category: Math Functions
This MySQL function extracts date or time information from a date or a datetime expression in the format type requested.
page views: 4,056;
category: Date & Time Functions
This MySQL function returns a random floating-point number from 0 to 1.
page views: 3,224;
category: Math Functions
This MySQL function returns the arccosine, in radians, of a given number.
page views: 3,231;
category: Math Functions
FIELD( )
This MySQL function searches for the first string given in the following list of strings and returns the numeric position of the first string in the list that matches.
page views: 2,980;
category: String Functions
This MySQL function releases a lock created by GET_LOCK().
page views: 8,572;
category: Table & Server Admin
This MySQL function can be used to add a given interval of time to a date or the value of a date column
page views: 3,334;
category: Date & Time Functions
This MySQL function returns the location of the first argument within a comma-separated list that is passed as a single stringin the second argument.
page views: 7,787;
category: String Functions
This MySQL function returns the string given in the first argument of the function, as many times as specified in the second argument.
page views: 3,832;
category: String Functions
Similar to ADDDATE(), but specifically and supposedly for adding time to a value. However, both MySQL functions allow the addition of date and time to a value.
page views: 4,727;
category: Date & Time Functions
This MySQL function rounds a given floating-point number down to the next lower integer.
page views: 3,269;
category: Math Functions
This MySQL function goes through the first argument and returns a string in which every occurrence of the second argument is replaced with third argument.
page views: 3,754;
category: String Functions
This MySQL function decrypts text that was encrypted using the AES algorithm with a 128-bit key length, reversing the AES_ENCRYPT() function.
page views: 4,379;
category: User & Security Statements
This MySQL function returns the given floating-point number with a comma inserted between every three digits and a period before the number of decimal places specified in the second argument
page views: 3,825;
category: Math Functions
This MySQL function returns the characters of string in reverse order.
page views: 3,340;
category: String Functions
AES_ENCRYPT( )
This MySQL function encrypts a given string using the AES algorithm with a 128-bit key length. It locks the encrypted string with the password given as the second argument.
page views: 3,012;
category: User & Security Statements
Use this MySQL function in conjunction with the SQL_CALC_FOUND_ROWS option of a SELECT statement to determine the number of rows an SQL statement using a LIMIT clause wou
page views: 3,996;
category: Other Functions
This MySQL function returns the final length characters from a string.
page views: 3,988;
category: String Functions
ANALYSE( )
This MySQL function returns an analysis of a results table from a SELECT statement.
page views: 3,068;
category: Other Functions
This MySQL function returns the date based on the number of days given, which are from the beginning of the currently used standard calendar.
page views: 5,395;
category: Date & Time Functions
ROUND( )
This MySQL function rounds a number given in the first argument to the nearest integer.
page views: 3,052;
category: Math Functions
This MySQL function returns the numeric code corresponding to the first character of a given string.
page views: 3,363;
category: String Functions
This MySQL function returns the date based on Unix time, which is the number of seconds since January 1, 1970, Greenwich Mean Time (GMT).
page views: 4,973;
category: Date & Time Functions
This MySQL function returns the number of rows changed by the previous SQL statement.
page views: 4,107;
category: Other Functions
ASIN( )
This MySQL function returns the arcsine, in radians, of a given number.
page views: 2,839;
category: Math Functions
This MySQL function returns the format for a given data type, based on the standard given as the second argument.
page views: 4,061;
category: Date & Time Functions
This MySQL function adds padding to the right end of string, stopping if the combination of string and the added padding reach length characters.
page views: 3,918;
category: String Functions
ASIN( )
This MySQL function returns the arcsine, in radians, of a given number.
page views: 3,091;
category: Math Functions
GET_LOCK( )
This MySQL function attempts to get a lock on the name given in the first argument.
page views: 3,138;
category: Table & Server Admin
RTRIM( )
This MySQL function returns the given string with any trailing spaces removed.
page views: 3,086;
category: String Functions
This MySQL function returns the arctangent, in radians, of a given number.
page views: 3,288;
category: Math Functions
GREATEST( )
This MySQL function compares two or more values, returning the greatest value.
page views: 3,100;
category: Math Functions
SCHEMA( )
This MySQL function returns the name of the database currently in use for the session.
page views: 2,919;
category: Other Functions
ATAN2( )
This MySQL function returns the arctangent, in radians, of X and Y for a point on a Cartesian plane.
page views: 3,118;
category: Math Functions
This MySQL function returns non-NULL values of a group concatenated by a GROUP BY clause, separated by commas.
page views: 3,990;
category: Aggregate Functions
This MySQL function returns the seconds value (0-59) for a given time.
page views: 3,848;
category: Date & Time Functions
This MySQL function returns the average or mean of a set of numbers given as the argument.
page views: 3,505;
category: Aggregate Functions
The first version of this MySQL function accepts a string and returns its numerical value, in hexadecimal, as it is represented in the underlying character set.
page views: 3,231;
category: String Functions
This MySQL function returns the period for a given number of seconds in the format hh:mm:ss.
page views: 8,325;
category: Date & Time Functions
BENCHMARK( )
Use this MySQL function to evaluate the performance of a MySQL server.
page views: 3,084;
category: Other Functions
HOUR( )
This MySQL function returns the hour for a DATETIME or TIME column.
page views: 3,164;
category: Date & Time Functions
This MySQL function returns the user name and the hostname for the current MySQL connection. The function takes no arguments.
page views: 4,723;
category: User & Security Statements
BIN( )
This MySQL function returns a binary number for a given integer.
page views: 3,010;
category: String Functions
This MySQL function returns the result given in the second argument if the condition given in the first argument is met (i.e., the condition does not equal 0 or NULL).
page views: 3,962;
category: Flow Control
SHA( )
This MySQL function returns the Secure Hash Algorithm (SHA) 160-bit checksum for the given string. The results are a string composed of 40 hexadecimal digits.
page views: 3,217;
category: User & Security Statements
BINARY
Use this MySQL function to treat strings in their binary state.
page views: 2,982;
category: String Functions
This MySQL function returns the results of the condition given in the first argument of the function if its results are not NULL.
page views: 3,219;
category: Flow Control
SIGN( )
This MySQL function returns -1 if the given number is a negative, 0 if it is zero, and 1 if it is positive.
page views: 2,936;
category: Math Functions
BIT_AND( )
This MySQL function returns the bitwise AND for all bits for the expression given. I'll confess here: I really have no idea what this does, although I wrote something about it.
page views: 3,105;
category: Aggregate Functions
This MySQL function converts an Internet Protocol (IP) address in dot-quad notation to its numeric equivalent.
page views: 4,044;
category: Math Functions
SIN( )
This MySQL function returns the sine of the number given, where number is expressed in radians.
page views: 3,115;
category: Math Functions
BIT_COUNT( )
This MySQL function returns the number of bits set in the argument, which is an integer that the function treats as a binary number.
page views: 3,193;
category: Math Functions
This MySQL function converts the numeric equivalent of an IP address to its dot-quad notation.
page views: 3,951;
category: Math Functions
This MySQL function pauses the execution of an SQL statement in which it is given, for the number of seconds given.
page views: 13,936;
category: Date & Time Functions
BIT_LENGTH( )
This MySQL function returns the number of bits in a given string.
page views: 2,984;
category: String Functions
INSERT( )
This MySQL function inserts the string from the final argument into the string specified by the first argument, at the specified position.
page views: 2,870;
category: String Functions
This MySQL function returns the results of a classic algorithm that can be used to compare two similar strings.
page views: 3,273;
category: String Functions
This MySQL function returns the bitwise OR for all bits for the expression given. It calculates with a 64-bit precision (BIGINT).
page views: 3,403;
category: Aggregate Functions
This MySQL function returns the starting position of the first occurrence of the substring in the string given as the first argument.
page views: 3,378;
category: String Functions
SPACE( )
This MySQL function returns a string of spaces.
page views: 2,900;
category: String Functions
BIT_XOR( )
This MySQL function returns the bitwise XOR (exclusive or) for all bits for the expression given. It calculates with a 64-bit precision (BIGINT).
page views: 3,039;
category: Aggregate Functions
INTERVAL( )
This MySQL function returns the position where search_value would be located in a comma-separated list of ordered_value arguments.
page views: 3,194;
category: String Functions
This MySQL function returns the square root of its input, which must be a positive number.
page views: 3,394;
category: Math Functions
CASE
This MySQL function produces results that vary based on which condition is true. It is similar to the IF( ) function except that multiple conditions and results may be strung together.
page views: 2,998;
category: Flow Control
Use this MySQL function to determine whether the value of the argument given in parentheses is NULL. It returns 1 if the value is NULL and 0 if it is not NULL.
page views: 3,731;
category: Flow Control
This MySQL function returns the population standard deviation of the given column.
page views: 3,418;
category: Aggregate Functions
Use this MySQL function to convert a value from one datatype to another.
page views: 3,382;
category: String Functions
Use this MySQL function to determine whether the name of the lock given in parentheses is free and available as a lock name.
page views: 7,194;
category: Table & Server Admin
STDDEV( )
This MySQL function returns the population standard deviation of the given column.
page views: 3,179;
category: Aggregate Functions
This MySQL function rounds a given floating-point number up to the next higher integer.
page views: 3,402;
category: Math Functions
This MySQL function determines whether the name given is already in use as a lock name.
page views: 3,604;
category: Table & Server Admin
This MySQL function returns the population standard deviation of the given column.
page views: 3,469;
category: Aggregate Functions
CEILING( )
This MySQL function rounds a given floating-point number up to the next higher integer.
page views: 2,881;
category: Math Functions
This MySQL function returns the date of the last day of the month for a given date or datetime value.
page views: 12,726;
category: Date & Time Functions
This MySQL function returns the sample standard deviation of the given column.
page views: 3,381;
category: Aggregate Functions
This MySQL function returns a string corresponding to the numeric code passed as the argument.
page views: 3,321;
category: String Functions
This MySQL function converts a string given to all lowercase letters.
page views: 3,849;
category: String Functions
This MySQL function compares two strings to determine whether the first string is before or after the second string in ASCII sequence.
page views: 6,318;
category: String Functions
CHARACTER_LENGTH( )
This MySQL function returns the number of characters of a given string.
page views: 2,967;
category: String Functions
LEAST( )
Use this MySQL function to compare two or more values and return the smallest value.
page views: 2,967;
category: Math Functions
This MySQL function returns the date and time of a given string for a given format.
page views: 3,436;
category: Date & Time Functions
CHARSET( )
This MySQL function returns the character set used by a given string.
page views: 2,774;
category: String Functions
This MySQL function returns the first length characters from a string.
page views: 3,964;
category: String Functions
Use this MySQL function to subtract a date or time interval from the results of a DATE or TIME data type column. It's an alias for DATE_SUB( ).
page views: 4,157;
category: Date & Time Functions
This MySQL function returns the number of characters in a given string.
page views: 5,514;
category: String Functions
LENGTH( )
This MySQL function returns the number of bytes contained in a given string.
page views: 2,895;
category: String Functions
SUBSTR( )
This MySQL function is an alias of SUBSTRING().
page views: 3,213;
category: String Functions
COALESCE( )
This MySQL function returns the leftmost non-NULL string or column in a comma-separated list.
page views: 3,202;
category: String Functions
LN( )
This MySQL function returns the natural logarithm of its input.
page views: 3,025;
category: Math Functions
This MySQL function returns the characters of a given string, starting from the position given.
page views: 4,003;
category: String Functions
This MySQL function returns an arbirary value known as the coercibility of a given string or other item, determning how likely that item is to determine the collation used in
page views: 3,338;
category: String Functions
This MySQL function reads the contents of a file and returns it as a string that may be used in MySQL statements and functions.
page views: 3,522;
category: String Functions
This MySQL function returns a substring of string, using delimiter to separate substrings and count to determine which of the substrings to return.
page views: 4,632;
category: String Functions
COLLATION( )
This MySQL function returns the collation for the character set of a given string.
page views: 2,848;
category: String Functions
LOCALTIME( )
This MySQL function returns the current system date in yyyy-mm-dd hh:mm:ss format. It's synonymous with LOCALTIMESTAMP( ) and NOW( ).
page views: 3,118;
category: Date & Time Functions
This MySQL function returns the date and time for the given string or column, decreased by the time given as the second argument (d hh:mm:ss).
page views: 8,260;
category: Date & Time Functions
COMPRESS( )
This MySQL function returns a given string after compressing it.
page views: 2,925;
category: String Functions
LOCALTIMESTAMP( )
This MySQL function is synonymous with LOCALTIME( ) and NOW( ).
page views: 3,030;
category: Date & Time Functions
This MySQL function returns the sum of the values for the given column or expression.
page views: 3,377;
category: Aggregate Functions
With this MySQL function, strings or columns can be concatenated or pasted together into one resulting field.
page views: 5,683;
category: String Functions
This MySQL function returns the numeric starting point of the first occurrence of a substring in the string supplied as a second argument.
page views: 5,630;
category: String Functions
This MySQL function returns the system date in the yyyy-mm-dd hh:mm:ss format at the time it's executed.
page views: 6,964;
category: Date & Time Functions
CONNECTION_ID( )
This MySQL function returns the MySQL connection or thread identification number for the MySQL session.
page views: 2,816;
category: Table & Server Admin
LOG( )
This MySQL function returns the logarithm of the first argument to the base indicated by the second argument.
page views: 3,086;
category: Math Functions
This MySQL function returns the user name and the hostname for the current MySQL connection. The function takes no arguments.
page views: 4,825;
category: User & Security Statements
CONV( )
This MySQL function converts a number from one numeric base system to another.
page views: 3,151;
category: Math Functions
LOG10( )
This MySQL function returns the base 10 logarithm of a given number.
page views: 2,947;
category: Math Functions
TAN( )
This MySQL function returns the tangent of an angle, where number is expressed in radians.
page views: 3,170;
category: Math Functions
CONVERT( )
Use this MySQL function to convert the character set of a given string to another character set specified with the USING keyword.
page views: 2,939;
category: String Functions
LOG2( )
This MySQL function returns the base-two logarithm of a given number.
page views: 2,931;
category: Math Functions
This MySQL function returns the time from a given string or column containing date and time data.
page views: 3,340;
category: Date & Time Functions
This MySQL function converts a date and time for given time zone to another which is specified.
page views: 5,934;
category: Date & Time Functions
LOWER( )
This MySQL function converts a string given to all lowercase letters.
page views: 2,972;
category: String Functions
This MySQL function returns the time difference between the two times given.
page views: 3,470;
category: Date & Time Functions
COS( )
This MySQL function returns the cosine of number, where number is expressed in radians.
page views: 3,100;
category: Math Functions
This MySQL function adds padding to the left end of string, stopping if the combination of string and the added padding reach length characters.
page views: 4,179;
category: String Functions
TIMESTAMP( )
This MySQL function merges the date and time from given strings or columns that contain date and time data separately; the result is returned in yyyy-mm-dd hh:mm:ss format.
page views: 2,970;
category: Date & Time Functions
COT( )
This MySQL function returns the cotangent of a number.
page views: 2,982;
category: Math Functions
LTRIM( )
This MySQL function returns the given string with any leading spaces removed.
page views: 3,120;
category: String Functions
This MySQL function adds the given number of intervals of time to the given date or time.
page views: 8,169;
category: Date & Time Functions
This MySQL function returns the number of rows retrieved in the SELECT statement for the given column.
page views: 4,451;
category: Aggregate Functions
This MySQL function determines the date requested from the start of the given year, by adding the number of days given.
page views: 3,876;
category: Date & Time Functions
This MySQL function returns the time difference between the two times given, but only for the interval being compared.
page views: 5,138;
category: Date & Time Functions
CRC32( )
This MySQL function returns the given string's cyclic redundancy check value as a 32-bit unsigned value.
page views: 2,906;
category: String Functions
MAKETIME( )
This MySQL function converts a given hour, minute, and second to hh:mm:ss format.
page views: 3,086;
category: Date & Time Functions
This MySQL function returns the time value of the time element provided and formats it according to formatting codes given.
page views: 3,823;
category: Date & Time Functions
This MySQL function returns the current system date in yyyy-mm-dd format.
page views: 4,783;
category: Date & Time Functions
This MySQL function converts the decimal number in bits to binary and returns a comma-separated list of values for all the bits that are set in that number, using string1 for the low-
page views: 3,646;
category: String Functions
This MySQL function returns the number of seconds that the given time represents.
page views: 5,507;
category: Date & Time Functions
CURRENT_DATE( )
This MySQL function is the same as CURDATE().
page views: 3,216;
category: Date & Time Functions
This MySQL function is used only for columns indexed by a FULLTEXT index, and only in WHERE clauses.
page views: 3,475;
category: String Functions
This MySQL function returns the date based on the number of days given, which are from the beginning of the currently used standard calendar.
page views: 3,290;
category: Date & Time Functions
CURRENT_TIME( )
This MySQL function returns the current time in hh:mm:ss format. This is synonymous with CURTIME( ).
page views: 3,121;
category: Date & Time Functions
MAX( )
This MySQL function returns the highest number in the values for a given column.
page views: 3,095;
category: Aggregate Functions
This MySQL function returns the given string with any trailing or leading padding removed, depending on which is specified.
page views: 13,411;
category: String Functions
This MySQL function returns the current date and time in yyyy-mm-dd hh:mm:ss format.
page views: 3,301;
category: Date & Time Functions
This MySQL function use an MD5 128-bit checksum to return a 32-character hash value of string from the RFC 1321 standard.
page views: 3,400;
category: User & Security Statements
TRUNCATE( )
This MySQL function returns a number equivalent to its first argument, removing any digits beyond the number of decimal places specified in the second argument.
page views: 2,904;
category: Math Functions
CURRENT_USER( )
This MySQL function returns the user name and the host that were given by the user for the current MySQL connection. It may not always return the same results as USER( ).
page views: 2,967;
category: User & Security Statements
This MySQL function extracts the microseconds value of a given time.
page views: 4,427;
category: Date & Time Functions
This MySQL function converts a string given to all uppercase letters.
page views: 3,944;
category: String Functions
This MySQL function returns the current system time in hh:mm:ss format.
page views: 3,920;
category: Date & Time Functions
This MySQL function returns the characters of a given string, starting from the position specified in the second argument.
page views: 3,933;
category: String Functions
UNCOMPRESS( )
This MySQL function returns the uncompressed string corresponding to the compressed string given, reversing the results of the COMPRESS( ) function.
page views: 3,012;
category: String Functions
DATABASE( )
This MySQL function returns the name of the database currently in use for the session.
page views: 2,945;
category: Other Functions
MIN( )
This MySQL function returns the lowest number in the values for a given column.
page views: 3,092;
category: Aggregate Functions
UNCOMPRESSED_LENGTH( )
This MySQL function returns the number of characters contained in the given compressed string before it was compressed.
page views: 2,652;
category: String Functions
DATE( )
This MySQL function returns the date from a given string, value, or expression that is submitted in a date or datetime format.
page views: 3,088;
category: Date & Time Functions
This MySQL function returns the minute value (0-59) of a given time.
page views: 4,318;
category: Date & Time Functions
This MySQL function converts hexadecimal numbers to their character equivalents.
page views: 4,149;
category: String Functions
This MySQL function returns the number of days of difference between the two dates given.
page views: 3,343;
category: Date & Time Functions
MOD( )
This MySQL function returns the remainder of a number given in the first argument when divided by the number given in the second argument, the modulo.
page views: 3,015;
category: Math Functions
UNIX_TIMESTAMP( )
This MySQL function returns the number of seconds since the start of the Unix epoch (January 1, 1970, Greenwich Mean Time).
page views: 3,042;
category: Date & Time Functions
Using the date or datetime given, this MySQL function adds the number of intervals specified. It's fairly synonymous with the ADDDATE( ) function.
page views: 6,460;
category: Date & Time Functions
This MySQL function returns the numeric value of the month (0-12) for the date provided.
page views: 4,159;
category: Date & Time Functions
UPPER( )
This MySQL function converts a given string to all uppercase letters.
page views: 3,085;
category: String Functions
This MySQL function returns a date and time in a desired format, based on formatting codes listed within quotes for the second argument of the function.
page views: 4,909;
category: Date & Time Functions
This MySQL function returns the name of the month for the date provided.
page views: 6,416;
category: Date & Time Functions
USER( )
This MySQL function returns the user name and the hostname for the current MySQL connection. The function takes no arguments.
page views: 1,479;
category: User & Security Statements
Use this MySQL function to subtract from the results of a date or time data type column. It's fairly synonymous with the SUBDATE( ).
page views: 4,825;
category: Date & Time Functions
This MySQL function returns the current date and time. The format returned is yyyy-mm-dd hh:mm:ss.nnnnnn. It's synonymous with LOCALTIME( ) and LOCALTIMESTAMP( ).
page views: 4,130;
category: Date & Time Functions
This MySQL function returns the current Universal Time, Coordinated (UTC) date in yyyy-mm-dd format.
page views: 3,261;
category: Date & Time Functions
DAY( )
This MySQL function returns the day of the month for a given date.
page views: 3,054;
category: Date & Time Functions
NULLIF( )
This MySQL function returns NULL if the two arguments given are equal. Otherwise, it returns the value or results of the first argument.
page views: 3,116;
category: Flow Control
UTC_TIME( )
This MySQL function returns the current Universal Time, Coordinated (UTC) time in hh:mm:ss format.
page views: 3,177;
category: Date & Time Functions
This MySQL function returns the name of the day for the date provided.
page views: 4,254;
category: Date & Time Functions
OCT( )
This MySQL function returns the octal or base 8 numeric system value of the given number.
page views: 3,096;
category: Math Functions
This MySQL function returns the current UTC date and time in yyyy-mm-dd hh:mm:ss format.
page views: 5,122;
category: Date & Time Functions
This MySQL function returns the day of the month for the date given.
page views: 4,384;
category: Date & Time Functions
OCTET_LENGTH( )
This MySQL function returns the number of bytes contained in the given string.
page views: 3,005;
category: String Functions
UUID ( )
This MySQL function returns a Universal Unique Identifier (UUID), a 128-bit number composed of five hexadecimal numbers.
page views: 3,054;
category: Other Functions
This MySQL function returns the numerical day of the week for a given date.
page views: 4,132;
category: Date & Time Functions
OLD_PASSWORD( )
This MySQL function encrypts a given string based on the password encryption method used prior to version 4.1 of MySQL. The result cannot be decrypted.
page views: 2,702;
category: User & Security Statements
With this MySQL function the variance is determined by taking the difference between each given value and the average of all values given.
page views: 6,165;
category: Aggregate Functions
DAYOFYEAR( )
This MySQL function returns the day of the year. January 1 would give a value of 1.
page views: 3,175;
category: Date & Time Functions
This MySQL function returns an ordinal value, the position of a character in the ASCII character set of the left-most character in a given string.
page views: 3,450;
category: String Functions
This MySQL function returns the variance of a given column, based on the rows selected as a population.
page views: 3,439;
category: Aggregate Functions
This MySQL function decrypts a given string that was encrypted with a given password. See also the ENCODE( ) function.
page views: 3,426;
category: User & Security Statements
This MySQL function encrypts a password given as an argument. The result cannot be decrypted.
page views: 4,884;
category: User & Security Statements
VAR_SAMP( )
This MySQL function returns the variance of a given column, based on the rows selected as a sample of a given population.
page views: 3,113;
category: Aggregate Functions
DEGREES( )
This MySQL function converts radians to degrees.
page views: 2,862;
category: Math Functions
This MySQL function adds a specified number of months to a period, which is a string containing only the year and month in either yyyymm or yymm format.
page views: 3,293;
category: Date & Time Functions
VERSION( )
This MySQL function returns the MySQL server version.
page views: 2,934;
category: Other Functions
This MySQL function decrypts text that was encrypted using the triple DES algorithm with a 128-bit key length, reversing the DES_ENCRYPT() func
page views: 3,578;
category: User & Security Statements
This MySQL function returns the number of months between periods given.
page views: 3,876;
category: Date & Time Functions
This MySQL function returns the number of the week starting from the beginning of the year for the date provided.
page views: 4,801;
category: Date & Time Functions
This MySQL function returns encrypted text using the triple DES algorithm with a 128-bit key length.
page views: 5,001;
category: User & Security Statements
PI( )
This MySQL function returns by default the first five decimal places of the number pi.
page views: 2,942;
category: Math Functions
This MySQL function returns the number for the day of the week. Monday is considered the first day of the week.
page views: 3,325;
category: Date & Time Functions
ELT( )
This MySQL function returns the index element from the list of strings given, where the list is numbered starting with 1.
page views: 3,122;
category: String Functions
POSITION( )
This MySQL function returns index of the character in string where substring first appears.
page views: 2,773;
category: String Functions
WEEKOFYEAR( )
This MySQL function returns the calendar week of the year for a given date. It's a bit synonymous with WEEK( ).
page views: 2,977;
category: Date & Time Functions
This MySQL function encrypts a given string in binary format and locks it with the password.
page views: 4,759;
category: User & Security Statements
POW( )
This MySQL function returns the result of raising the number given in the first argument to the exponent given in the second argument.
page views: 3,030;
category: Math Functions
This MySQL function returns the year of the date provided.
page views: 3,713;
category: Date & Time Functions
ENCRYPT( )
This MySQL function returns encrypted text using the C-language crypt function.
page views: 2,726;
category: User & Security Statements
POWER( )
This MySQL function returns the result of raising the number given in the first argument to the power of the number given in the second argument.
page views: 2,991;
category: Math Functions
This MySQL function returns the year coupled with the number of the week into the year: yyyyww. By default, the first day of the week is Sunday and the basis of the calculation.
page views: 3,671;
category: Date & Time Functions
EXP( )
This MySQL function returns the value of the natural logarithm base number e to the power of the given number.
page views: 3,029;
category: Math Functions
This MySQL function returns the number of the quarter (1-4) for the date provided. The first quarter (i.e., three months) of each year has a value of 1.
page views: 6,918;
category: Date & Time Functions