String Functions
| Function | Description |
|---|---|
| LENGTH() | Returns the number of characters in a string |
| LOWER() | Makes string lowercase |
| UPPER() | Makes string upper case |
| STARTS_WITH() | Checks if a string starts with a specified substring |
| ENDS_WITH() | Checks if a string ends with a specified substring |
| CONCAT() | Adds two or more strings together |
| SUBSTR() | Extracts a substring from a string |
| STRPOS() | Finds the position at which the substring starts within the string |
| REGEXP_MATCH() | Matches a POSIX regular expression pattern to a string |
| REGEXP_REPLACE() | Substitutes new text for substrings that match POSIX regular expression patterns |
| REPLACE() | Finds and replace occurences of a substring in a string |
| POSITION() | Returns the position of the first occurrence of a substring in a string |
String Operators
| Operator | Description |
|---|---|
| text ~ text -> boolean | Returns true if the first argument matches the pattern of the second argument in case sensitive match |
| text ~* text -> boolean | Returns true if the first argument matches the pattern of the second argument in a case-insensitive match |
| text !~ text -> boolean | Returns true if the first argument does not match the pattern of the second argument in case sensitive match. |
| text !~* text -> boolean | Returns true if the first argument does not match the pattern of the second argument in a case-insensitive match |