In MySQL, the LOWER() function converts uppercase characters to lowercase, according to the current character set mapping (the default mapping is utf8mb4).
Category: MySQL
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).
How the TO_BASE64() Function Works in MySQL
In MySQL, the TO_BASE64() function converts a string to a base-64 encoded string and returns the result.
How the FROM_BASE64() Function Works in MySQL
In MySQL, the FROM_BASE64() function decodes a base-64 encoded string and returns the result. More specifically, it takes a string encoded with the base-64 encoded rules used by TO_BASE64() and returns the decoded result as a binary string.
CHAR() Examples in MySQL
In MySQL, the CHAR() function returns the character for each integer passed. In other words, you can pass in one or more integers, and the function will interpret those as code values for string characters and return the corresponding string for each code value.
How the EXPORT_SET() Function Works in MySQL
The MySQL EXPORT_SET() function returns a string that represents the bits in a number.
You have the ability to customise how the function outputs the string. The function accepts a number of arguments that allows you to do this. When you call the function, you provide the number in question, as well as arguments that determine how the results are displayed.
MySQL Mathematical Functions (Full List)
MySQL includes a bunch of functions and operators that can help us when working with data.
The following is a list of mathematical functions available in MySQL. You can click on each function name to see an explanation of the function, its syntax, and examples.
MySQL TRUNCATE() Function – Truncate a Number to a Specified Number of Decimal Places
In MySQL, the TRUNCATE() function truncates a value to a specified number of decimal places.
The function accepts two arguments; the value, and the number of decimal places to truncate that value to.
All numbers are rounded toward zero.
MySQL TAN() Function – Return the Tangent of a Value in MySQL
In MySQL, the TAN() function returns the tangent of a value.
You provide the value as an argument when calling the function.
MySQL SQRT() Function – Return the Square Root of a Number in MySQL
In MySQL, the SQRT() function returns the square root of a nonnegative number.
You provide the number as an argument when calling the function.