We also accepts escaped characters withing string constants, which are

an extension to the SQL standard. Within an escape string, a

which the combination of backslash and following character(s)

<td>The LIKE expression returns true if the string matches the supplied pattern.

(As expected, the <code>NOT LIKE</code> expression returns false if LIKE returns true.</td>

<td>See below for details.</td>

The <code>ILIKE</code> expression returns true if the string matches the supplied pattern,

See below for details.

<td>The RLIKE expression returns true if the string matches the supplied pattern.

<td>Returns the numeric code of the first character of the argument. In UTF8 encoding, returns the Unicode code point of the character. In other multibyte encodings, the argument must be an ASCII character. Returns 0 if the string is empty.</td>

<td>Returns number of characters in the string.</td>

<td>Returns a string containing the character with the given code. If the code is incorrect (e.g., negative), the result is an empty string.</td>

<td>Converts the first letter of each word to upper case and the rest to lower case. Words are sequences of alphanumeric characters separated by non-alphanumeric characters.</td>

<td>Converts the first letter of each word to upper case and the rest to lower case. Words are sequences of characters separated by spaces.</td>

<td>Returns first <code>count</code> characters in the string. If any argument is <code>NULL</code>, return <code>NULL</code>.</td>

<td>Converts the string to all lower case.</td>

Calculates an MD5 128-bit checksum of string and returns it as a hex <code>VARCHAR</code> value.

<td>Replaces the substring of string that starts at the start'th character and extends for remove characters with newsubstring. If count is omitted, it defaults to the length of newsubstring. If 'start' is not positive, the original string is unchanged. If 'start' is bigger than the length of 'string', the result is the concatenation of the two strings. If 'remove' is negative it is considered 0.</td>

<td>Returns the first Unicode character index of the specified substring within string, or zero if it's not present. First character has index 1.</td>

<td>Repeats string the specified number of times. The result is an empty string for a negative or 0 count.</td>

<td>Produce an array of strings, by splitting the first argument at each delimiter occurrence.

If the delimiter is empty, return an array with the original string. If the original

string is empty, return an empty array. If either argument is `NULL`, return `NULL`.

If delimiter is absent assume it is the string <code>','</code>.</td>

This function uses 1-based indexing. It extracts the <code>n</code>'th part of the string by splitting it at each occurrence of the delimiter.

<li><code>n = 1</code> refers to the first part of the string after splitting.</li>

<li>If <code>n</code> is negative, it returns the <code>abs(n)</code>'th part from the end of the string.</li>

<td>Extracts the substring of string starting at the "start"'th character, and stopping after "length" characters if the value is specified. If "start" is negative, the first character is chosen counting backwards from the end of the string. If "count" is negative the empty string is returned. The index of the first character is 1.</td>

<td>Extracts the substring of string starting at the "start"'th character, and stopping after "count" characters if the value is specified. If "start" is negative, only max(count + start - 1, 0) characters are returned. If "count" is negative the empty string is returned. The index of the first character is 1.</td>

<td>Remove the specified characters from the specified ends of the string argument</td>

<td>Converts the string to all upper case.</td>

If pattern does not contain percent signs or underscores, then the

like the equals operator. An underscore (`_`) in pattern stands for

but a different one can be selected by using the ESCAPE clause. To

The `ILIKE` expression performs a case-insensitive pattern match. If the pattern does not contain percent signs or underscores, then the pattern represents the string itself, and `ILIKE` acts like the equals operator, ignoring character case. An underscore (`_`) in the pattern matches any single character, while a percent sign (`%`) matches any sequence of zero or more characters.