String Functions
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. |
It returns true if the first argument starts with the second argument. | |
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). |
Substitutes new text for substrings that match POSIX regular expression patterns. | |
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. |