MYSQL in a Nutshell (In a Nutshell (OReilly))

2017-07-07 02:10:07

The list of string functions is quite long, but many perform similar roles. The following list groups the functions by these roles.

5.1.1. Converting

ASCII( ), BIN( ), BINARY( ), CHAR( ), COMPRESS( ), CONV( ), EXPORT_SET( ), HEX( ), INET_ATON( ), INET_NTOA( ), MAKE_SET( ), OCT( ), ORD( ), SOUNDEX( ), UNCOMPRESS( ), UNHEX( )

5.1.2. Formatting

CONCAT( ), CONCAT_WS( ), LCASE( ), LENGTH( ), LOWER( ), LPAD( ), LTRIM( ), OCTET_LENGTH( ), QUOTE( ), RPAD( ), RTRIM( ), SPACE( ), TRIM( ), UCASE( ), UPPER( )

5.1.3. Expressions

BIT_LENGTH( ), CHAR_LENGTH( ), CHARACTER_LENGTH( ), ELT( ), FIELD( ), FIND_IN( ), INSTR( ), LOCATE( ), MATCH( ), AGAINST( ), POSITION( ), STRCMP( ), SUBSTRING_INDEX( ), UNCOMPRES_LENGTH()

5.1.4. Extracting

LEFT( ), LOAD_FILE( ), MID( ), RIGHT( ), SUBSTRING( )

5.1.5. Manipulating

INSERT( ), REPEAT( ), REPLACE( ), REVERSE( )

5.1.6. Security

DECODE( ), ENCODE( ), ENCRYPT( ), MD5( ), PASSWORD( )