string functions

How the OCT() Function Works in MySQL

November 19, 2019April 2, 2019 by Ian

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.

How The SUBSTR() Function Works in MySQL

February 14, 2020March 14, 2019 by Ian

In MySQL, the SUBSTR() function returns a substring starting from the specified position.

Both SUBSTR() and MID() are synonyms of SUBSTRING().

How the MID() Function Works in MySQL

February 14, 2020February 28, 2019 by Ian

In MySQL, the MID() function returns a substring starting from the specified position.

Both MID() and SUBSTR() are synonyms of SUBSTRING().

How the RTRIM() Function Works in MySQL

November 19, 2019January 31, 2019 by Ian

In MySQL, the RTRIM() function trims whitespace from the right-hand side of a string.

How the LTRIM() Function Works in MySQL

November 19, 2019January 26, 2019 by Ian

In MySQL, the LTRIM() function trims whitespace from the beginning of a string.

How the RPAD() Function Works in MySQL

November 19, 2019January 25, 2019 by Ian

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.

How the LPAD() Function Works in MySQL

November 19, 2019January 24, 2019 by Ian

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.

How the LOCATE() Function Works in MySQL

November 19, 2019January 16, 2019 by Ian

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

November 19, 2019January 15, 2019 by Ian

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

How the RIGHT() Function Works in MySQL

November 19, 2019January 14, 2019 by Ian

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