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

Continue Reading## 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

Continue Reading## 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

Continue Reading## 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

Continue Reading## 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

Continue Reading## MySQL String Functions Part-6

RPAD Function:- RPAD Function is used for adding string on the right side of the original string. Syntax:- RPAD(string, length, pad string) For Example:- SELECT RPAD(“kshtutor”, 13, “^”); Output:- kshtutor^^^^^ SELECT RPAD(“kshtutor”, 12, “srkp”); Output:-

Continue Reading## 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

Continue Reading## 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

Continue Reading## MySQL String Functions Part-3

ExtractValue Function:- ExtractValue Function is an XML function in MySQL. It retrieves data from XML content. It takes two arguments, the first argument will be text CDATA and the second argument will be Locator. Syntax:-

Continue Reading## MySQL String Functions Part-2

CONCAT Function:- CONCAT function adds or concatenate two or more argument or expression. If any argument is a NULL value then It returns NULL. If any argument is a binary value It returns Binary. If

Continue Reading