In MySQL, the LPAD() function allows you to pad the left part of a string with one or more characters.
The way it works is, you specify the string to pad, the length of the padding, as well as the string of characters to use for the padding.
Category: Relational
How the LOCATE() Function Works in MySQL
In MySQL, the LOCATE() function returns the position of a substring within a string. More specifically, it returns the position of the first occurrence within the string, or the first occurrence after a given starting point.
How the LOAD_FILE() Function Works in MySQL
In MySQL, the LOAD_FILE() function reads a file and returns its contents as a string.
How the RIGHT() Function Works in MySQL
In MySQL, the RIGHT() function returns the rightmost characters from a string. The number of characters returned is determined by the second argument.
How the LEFT() Function Works in MySQL
In MySQL, the LEFT() function returns the leftmost characters from a string. The number of characters returned is determined by the second argument.
How the UCASE() Function Works in MySQL
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).
How the UPPER() Function Works in MySQL
In MySQL, the UPPER() function converts lowercase characters to uppercase, according to the current character set mapping (the default mapping is utf8mb4).
How the LCASE() Function Works in MySQL
How the LOWER() Function Works in MySQL
In MySQL, the LOWER() function converts uppercase characters to lowercase, according to the current character set mapping (the default mapping is utf8mb4).
How the INSTR() Function Works in MySQL
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).