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. ConvertingASCII( ), BIN( ), BINARY( ), CHAR( ), COMPRESS( ), CONV( ), EXPORT_SET( ), HEX( ), INET_ATON( ), INET_NTOA( ), MAKE_SET( ), OCT( ), ORD( ), SOUNDEX( ), UNCOMPRESS( ), UNHEX( ) 5.1.2. FormattingCONCAT( ), CONCAT_WS( ), LCASE( ), LENGTH( ), LOWER( ), LPAD( ), LTRIM( ), OCTET_LENGTH( ), QUOTE( ), RPAD( ), RTRIM( ), SPACE( ), TRIM( ), UCASE( ), UPPER( ) 5.1.3. ExpressionsBIT_LENGTH( ), CHAR_LENGTH( ), CHARACTER_LENGTH( ), ELT( ), FIELD( ), FIND_IN( ), INSTR( ), LOCATE( ), MATCH( ), AGAINST( ), POSITION( ), STRCMP( ), SUBSTRING_INDEX( ), UNCOMPRES_LENGTH() 5.1.4. ExtractingLEFT( ), LOAD_FILE( ), MID( ), RIGHT( ), SUBSTRING( ) 5.1.5. ManipulatingINSERT( ), REPEAT( ), REPLACE( ), REVERSE( ) 5.1.6. SecurityDECODE( ), ENCODE( ), ENCRYPT( ), MD5( ), PASSWORD( ) |