## MySQL Numeric or Mathematical Function Part5

POW Function:- POW Function is used for returning the value of a number raised to the power of another number. This function is similar to the POWER function. Syntax:- If base = b and exponent

## MySQL Numeric or Mathematical Function Part4

LN Function:- LN Function is used for returning the natural logarithm of a given number. If the number will be zero or less than zero then it will return NULL. The EXP() is the opposite

## MySQL Numeric or Mathematical Function Part3

DEGREES Function:- DEGREES Function is used for converting radian value into a degree. Syntax:- DEGREES(radian value) For Example:- SELECT DEGREES(PI()/2); Output:- 90 SELECT DEGREES(1.57079); Output:- 89.99963750135457 SELECT ROUND(DEGREES(1.57079)); Output:- 90 DIV Function:- DIV Function is

## MySQL Numeric or Mathematical Function Part2

AVG Function:- AVG Function is used for returning the average value of a given list of numeric values. Syntax:- AVG(List of numeric value) For Example:- SELECT * FROM Employee WHERE age > (SELECT AVG(age) FROM

## MySQL Numeric or Mathematical Function Part1

ABS Function:- The ABS Function is used for returning an absolute positive value. Syntax:- ABS(NUMBER) For Example:- SELECT ABS(47.5); output:- 47.5 SELECT ABS(-47.5); output:- 47.5 ACOS Function:- ACOS Function is used for returning arc cosine

## MySQL String Functions Part-5

MATCH Function:- The MATCH Function is used for full-text searches. It performs a case-insensitive search. It is required to make a full-text index on the table before performing a full-text search. InnoDB and MyISAM engine

## MySQL String Functions Part-4

LCASE Function:- LCASE Function is used to convert strings in lowercase. LOWER() and LCASE() both perform the same task. We can say LCASE() is a synonym of LOWER(). Syntax:- LCASE(string) For Example:- SELECT LCASE(“MySQL is