Additional languages
« 12.9 Cast Functions and Operators
12.10.1 Bit Functions »
Section Navigation      [Toggle]

12.10. Other Functions

12.10.1. Bit Functions
12.10.2. Encryption and Compression Functions
12.10.3. Information Functions
12.10.4. Miscellaneous Functions
Name Description
AES_DECRYPT() Decrypt using AES
AES_ENCRYPT() Encrypt using AES
BENCHMARK() Repeatedly execute an expression
BIT_AND() Return bitwise and
BIT_COUNT() Return the number of bits that are set
BIT_OR() Return bitwise or
BIT_XOR() Return bitwise xor
& Bitwise AND
| Bitwise OR
^ Bitwise XOR
CHARSET() Return the character set of the argument
COERCIBILITY() Return the collation coercibility value of the string argument
COLLATION() Return the collation of the string argument
COMPRESS() Return result as a binary string
CONNECTION_ID() Return the connection ID (thread ID) for the connection
COUNT() Return a count of the number of rows returned
CURRENT_USER(), CURRENT_USER Return the username and hostname combination
DATABASE() Return the default (current) database name
DECODE() Decodes a string encrypted using ENCODE()
DEFAULT() Return the default value for a table column
DES_DECRYPT() Decrypt a string
DES_ENCRYPT() Decrypt a string
ENCODE() Encode a string
ENCRYPT() Encrypt a string
FORMAT() Return a number formatted to specified number of decimal places
FOUND_ROWS() For a SELECT with a LIMIT clause, the number of rows that would be returned were there no LIMIT clause
GET_LOCK() Get a named lock
INET_ATON() Return the numeric value of an IP address
INET_NTOA() Return the IP address from a numeric value
IS_FREE_LOCK() Checks whether the named lock is free
IS_USED_LOCK() Checks whether the named lock is in use. Return connection identifier if true.
LAST_INSERT_ID() Value of the AUTOINCREMENT column for the last INSERT
<< Left shift
MASTER_POS_WAIT() Block until the slave has read and applied all updates up to the specified position
MD5() Calculate MD5 checksum
NAME_CONST()(v5.0.12) Causes the column to have the given name
OLD_PASSWORD() Return the value of the old (pre-4.1) implementation of PASSWORD
PASSWORD() Calculate and return a password string
RELEASE_LOCK() Releases the named lock
>> Right shift
ROW_COUNT() The number of rows updated
SCHEMA() A synonym for DATABASE()
SESSION_USER() Synonym for USER()
SHA1(), SHA() Calculate an SHA-1 160-bit checksum
SLEEP() Sleep for a number of seconds
SYSTEM_USER() Synonym for USER()
~ Invert bits
UNCOMPRESS() Uncompress a string compressed
UNCOMPRESSED_LENGTH() Return the length of a string before compression
USER() Return the current username and hostname
UUID() Return a Universal Unique Identifier (UUID)
VALUES() Defines the values to be used during an INSERT