Database.Guide

In MySQL, the LOAD_FILE() function reads a file and returns its contents as a string.

Read more

In MySQL, the RIGHT() function returns the rightmost characters from a string. The number of characters returned is determined by the second argument.

Read more

In MySQL, the LEFT() function returns the leftmost characters from a string. The number of characters returned is determined by the second argument.

Read more

In MySQL, the UCASE() function is a synonym for UPPER(). In other words, you can use either of these functions to do the same thing.

Specifically, both functions convert lowercase characters to uppercase (and return the result), according to the current character set mapping (the default mapping is utf8mb4).

Read more

In MySQL, the UPPER() function converts lowercase characters to uppercase, according to the current character set mapping (the default mapping is utf8mb4).

Read more

In MySQL, the LCASE() function is a synonym for LOWER(). In other words, you can use either of these functions to do the same thing.

Specifically, both functions convert uppercase characters to lowercase, according to the current character set mapping (the default mapping is utf8mb4).

Read more

In MySQL, the LOWER() function converts uppercase characters to lowercase, according to the current character set mapping (the default mapping is utf8mb4).

Read more

The INSTR() function returns the position of the first occurrence of a substring within a string. Basically, it does the same thing that the two-argument syntax of the LOCATE() function does (except that the order of the arguments is reversed).

Read more

In MySQL, the FROM_BASE64() function decodes a base-64 encoded string and returns the result. More specifically, it takes a string encoded with the base-64 encoded rules used by TO_BASE64() and returns the decoded result as a binary string.

Read more