website logo
⌘K
🏠Homepage
👋Introduction
Key Concepts & Architecture
🚀Getting Started
👨‍💻SQL Reference
SQL Queries
SQL Clauses
SQL Data Types
SQL Functions
Schema
🚨Error Handling
🆚Differences Between Oxla vs. PostgreSQL
Docs powered by archbee 

String Functions

1min

String functions are used to analyze and manipulate string values. Oxla supports the following String functions:

Functions

Description

LENGTH()

Returns the number of characters in a string.

LOWER()

Makes string lowercase.

UPPER()

Makes string upper case.

STARTS_WITH()

It returns true if the first argument starts with the second argument.

ENDS_WITH()

It returns true if the first argument ends with the second argument.

CONCAT()

Concatenates all inputs into a single result.

Concatenates all inputs into a single result.

Concatenates all inputs into a single result.

Concatenates all inputs into a single result.

Concatenates all inputs into a single result.

SUBSTR()

Retrieves substring.

STRPOS()

Finds the position at which the substring (defined as a second argument) starts within the string (defined as a first argument).

REGEXP_REPLACE()

Substitutes new text for substrings that match POSIX regular expression patterns.

REPLACE()

Finds and replaces a substring with a new one in a string.

String operators:

Functions

Description

text ~ text -> boolean

Return true if the first argument matches the pattern of the second argument in case sensitive match.

text ~* text -> boolean

Return true if first argument matches pattern of second argument in case sensitive match.

Return true if the first argument matches the pattern of the second argument in a case-insensitive match.

text !~ text -> boolean

Return true if the first argument does not match the pattern of the second argument in case sensitive match.

text !~* text -> boolean

Return true if the first argument does not match the pattern of the second argument in a case-insensitive match.

 

Updated 11 May 2023
Did this page help you?
Yes
No
PREVIOUS
BOOL_OR
NEXT
LENGTH
Docs powered by archbee 

Dedicated to data analytics that provides 10x faster execution of analytical queries than current state of the art solutions. We are launching SOON! Join the waiting list for more info.




©2022 Oxla