X
  • Search
  • Products
  • Services
  • Resources
  • About
  • Contact
  • Login

Copyright © 2025 MariaDB. All rights reserved.

The Ultimate Guide to High Availability with MariaDB
Download Now
  • Knowledge Base
  • Contact
  • Login
  • Search
  • Products
  • Solutions
  • Resources
  • Company
  • Pricing
  • Download
Knowledge Base » MariaDB Server Documentation » Using MariaDB Server » SQL Statements & Structure » SQL Statements » Built-in Functions » String Functions » SUBSTR
  • Home
  • Open Questions
  • MariaDB Server
  • MariaDB MaxScale
  • MariaDB ColumnStore
  • Connectors
History Source Flag as Spam / Inappropriate Translate
Created
14 years, 12 months ago
Modified
6 years, 10 months ago
Type
article
Status
active
License
GPLv2 fill_help_tables.sql
  • History
  • Comments
Edit
Attachments
No attachments exist
Localized Versions
  • SUBSTR [it]

SUBSTR

Description

SUBSTR() is a synonym for SUBSTRING().

  • ← STRCMP
  • ↑ String Functions ↑
  • SUBSTRING →

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
  • ↑ String Functions ↑
  • Regular Expressions Functions
  • Dynamic Columns Functions
  • ASCII
  • BIN
  • BINARY Operator
  • BIT_LENGTH
  • CAST
  • CHAR Function
  • CHARACTER_LENGTH
  • CHAR_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
  • Full-Text Index Stopwords
  • 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
  • UCASE
  • UNCOMPRESS
  • UNCOMPRESSED_LENGTH
  • UNHEX
  • UPDATEXML
  • UPPER
  • WEIGHT_STRING
  • Type Conversion
  • Products
  • Solutions
  • Resources
  • Company
  • Pricing
  • Download MariaDB
Subscribe to our newsletter!
  • Legal
  • Privacy Policy
  • Cookie Policy

Copyright © 2025 MariaDB. All rights reserved.