In MySQL, the POSITION() function returns the position of the first occurrence of a substring within the string.
This function is actually a synonym for LOCATE(), but with a slightly different syntax. The LOCATE() function also has extra functionality, in that it allows you to define a starting position fro your search.
In MySQL, the OCT() function is used for converting from decimal to octal.
More precisely, it returns a string representation of the octal value of its argument.
In MySQL, the SUBSTR() function returns a substring starting from the specified position.
Both SUBSTR() and MID() are synonyms of SUBSTRING().
In MySQL, the MID() function returns a substring starting from the specified position.
Both MID() and SUBSTR() are synonyms of SUBSTRING().
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.