Webinar | The MariaDB MaxScale Advantage: Achieving True Enterprise High Availability
Register Now
LogoLogo
CtrlK
Download MariaDBContact Us
  • Home
  • MariaDB Platform
  • Server
  • MaxScale
  • Analytics
  • Galera Cluster
  • Connectors
  • Tools
  • MariaDB Cloud
  • Release Notes
  • General Resources
  • MariaDB Server Documentation
  • Quickstart Guides
  • Server Usage
  • Server Management
  • Security
  • Architecture
  • Clients & Utilities
  • HA & Performance
  • Reference
    • SQL Structure
    • SQL Statements
    • SQL Functions
      • Functions & Operators
      • Aggregate Functions
      • Control Flow Functions
      • Date & Time Functions
      • Numeric Functions
      • Pseudo Columns
      • Secondary Functions
      • Special Functions
      • String Functions
        • 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
      • Vector Functions
    • Data Types
    • Plugins
    • System Tables
    • Error Codes
    • Client/Server Protocol
Powered by GitBook
On this page

Was this helpful?

  1. Reference
  2. SQL Functions

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.

ASCIIBINBINARY OperatorBIT_LENGTHCASTCHAR FunctionCHAR_LENGTHCHARACTER_LENGTHCHRCONCATCONCAT_WSCONVERTELTEXPORT_SETEXTRACTVALUEFIELDFIND_IN_SETFORMATFROM_BASE64HEXINSERT FunctionINSTRLCASELEFTLENGTHLENGTHBLIKELOAD_FILELOCATELOWERLPADLTRIMMAKE_SETMATCH AGAINSTMIDNATURAL_SORT_KEYNOT LIKENOT REGEXPOCTET_LENGTHORDPOSITIONQUOTEREPEAT FunctionREPLACE FunctionREVERSERIGHTRPADRTRIMSFORMATSOUNDEXSOUNDS LIKESPACESTRCMPSUBSTRSUBSTRINGSUBSTRING_INDEXTO_BASE64TO_CHARTRIMTRIM_ORACLEType ConversionUCASEUNHEXUPDATEXMLUPPERWEIGHT_STRINGRegular Expressions Functions

Last updated 4 months ago

Was this helpful?

LogoLogo

Products

  • Enterprise Platform
  • Community Server
  • Download MariaDB
  • Pricing

Support

  • Customer Login
  • Technical Support
  • Remote DBA
  • Professional Services

Resources

  • MariaDB Blog
  • Webinars
  • Customer Stories
  • MariaDB Events
  • Documentation
  • Developer Hub

Company

  • About MariaDB
  • Newsroom
  • Leadership
  • MariaDB Careers
  • Legal
  • Privacy Policy

© 2025 MariaDB. All rights reserved.