In MySQL, the UNHEX() function allows you to “unhex” a string in MySQL. In other words, it allows you to convert a hexadecimal value to a human-readable string.
Specifically, the function interprets each pair of characters in the argument as a hexadecimal number and converts it to the byte represented by the number. The return value is a binary string.
In MySQL, the TRIM() function trims whitespace (or other specified characters) from the start and/or end of a string.
You can specify whether to trim from the left side, the right side, or both sides of the string.
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 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.