How can we combine functions in MySQL?

Combining of functions in MySQL is quite possible by providing a function as the argument of other function. It is also called nesting of functions. To understand it, consider some examples below

mysql> Select UPPER(CONCAT('www.','tutorialspoint','.com'))As Tutorials;
+------------------------+
| Tutorials              |
+------------------------+
| WWW.TUTORIALSPOINT.COM |
+------------------------+
1 row in set (0.00 sec)

mysql> Select LOWER(CONCAT('WWW.','TUTORIALSPOINT','.COM'))As Tutorials;
+------------------------+
| Tutorials              |
+------------------------+
| www.tutorialspoint.com |
+------------------------+
1 row in set (0.00 sec)

The above queries combine UPPER() and LOWER() function with CONCAT() function.

Similarly, we can combine more functions with each other; eve more than two functions can also be combined.

Chandu yadav

Published on 21-Feb-2018 05:29:52

• Related Questions & Answers
• Can we combine MySQL IN AND LIKE operators?
• How can we combine ROW selection with COLUMN selection in MySQL?
• How can we calculate the Date in MySQL using functions?
• How can we distinguish between MySQL IFNULL() and NULLIF() functions?
• Can we combine GridLayout and BorderLayout in Java?
• What are MySQL stored functions and how can we create them?
• How can we create recursive functions in Python?
• How can we combine the values of two or more columns of MySQL table?
• How can we combine multiple print statements per line in Python?
• How can we stuff a string with another one using MySQL functions?
• How can we use group functions with non-group fields in MySQL SELECT query?
• How we can store Python functions in a Sqlite table?
• How can we see only the list of stored functions in a particular MySQL database?
• How can we use the output of LTRIM() and RTRIM() functions to update MySQL table?
• How can we create MySQL views?