In MySQL, the MAKE_SET() function returns a set value (a string containing substrings separated by , characters) consisting of the characters specified as arguments when you call the function.
When you call the function, you specify any number of strings (separated by a comma), as well as one or more bit values that determine which strings to return in the set value.
In MySQL, the RTRIM() function trims whitespace from the right-hand side of a string.
In MySQL, the LTRIM() function trims whitespace from the beginning of a string.
In MySQL, the RPAD() function allows you to pad the right 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.
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.
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.
In MySQL, the LOAD_FILE() function reads a file and returns its contents as a string.
In MySQL, the RIGHT() function returns the rightmost characters from a string. The number of characters returned is determined by the second argument.
In MySQL, the LEFT() function returns the leftmost characters from a string. The number of characters returned is determined by the second argument.
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).