Remove the longest string consisting only of characters in characters from the start and end of string.
SQL equivalent: btrim
Number of characters in string
SQL equivalent: char_length, length
Character with the given code. For UTF8 the argument is treated as a Unicode code point. For other multibyte encodings the argument must designate an ASCII character. The NULL (0) character is not allowed because text data types cannot store such bytes.
SQL equivalent: chr
Convert string to lower case
SQL equivalent: lower
Remove all space characters from the start of string.
SQL equivalent: ltrim
Remove the longest string consisting only of characters in characters from the start of string.
SQL equivalent: ltrim
Remove all space characters from the end of string.
SQL equivalent: rtrim
Remove the longest string consisting only of characters in characters from the end of string.
SQL equivalent: rtrim
Location of specified substring. The first character in the haystack is 1 (not 0). A result of 0 means that the substring was not found.
SQL equivalent: strpos, position
Extract substring. The first character in the string has index 1. Extracts starting from "from" until the end of the string.
SQL equivalent: substr, substring
Extract substring. The first character in the string has index 1. Extracts starting from "from" for "count" characters.
SQL equivalent: substr, substring
Convert number to its equivalent hexadecimal representation.
SQL equivalent: to_hex
Convert string to upper case
SQL equivalent: upper
Generated using TypeDoc
Remove all space characters from the start and end of string.
SQL equivalent: btrim