SUBSTRING

Returns a substring starting from a specified position. Alias for SUBSTR.

Analyze Syntax

func.substring(<str>, <pos>[, <len>])

Analyze Examples

func.substring('StarRocks', 1, 4)

┌────────┐
 'Star'  
└────────┘

SQL Syntax

SUBSTRING(<str>, <pos>[, <len>])

SQL Examples

SELECT SUBSTRING('StarRocks', 1, 4);

┌──────┐
 Star  
└──────┘