String Functions

Learn about string functions in MariaDB Server. This section details SQL functions for manipulating, searching, and formatting text strings, essential for data cleansing and presentation.

ASCII BIN BINARY Operator BIT_LENGTH CAST CHAR Function CHAR_LENGTH CHARACTER_LENGTH CHR CONCAT CONCAT_WS CONVERT ELT EXPORT_SET EXTRACTVALUE FIELD FIND_IN_SET FORMAT FROM_BASE64 HEX INSERT Function INSTR LCASE LEFT LENGTH LENGTHB LIKE LOAD_FILE LOCATE LOWER LPAD LTRIM MAKE_SET MATCH AGAINST MID NATURAL_SORT_KEY NOT LIKE NOT REGEXP OCTET_LENGTH ORD POSITION QUOTE REPEAT Function REPLACE Function REVERSE RIGHT RPAD RTRIM SFORMAT SOUNDEX SOUNDS LIKE SPACE STRCMP SUBSTR SUBSTRING SUBSTRING_INDEX TO_BASE64 TO_CHAR TRIM TRIM_ORACLE Type Conversion UCASE UNHEX UPDATEXML UPPER WEIGHT_STRING Regular Expressions Functions

PreviousROW_NUMBER NextASCII

Last updated 7 months ago

Was this helpful?