

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
- 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?
- What are MySQL stored functions and how can we create them?
- Can we combine GridLayout and BorderLayout in Java?
- 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 stuff a string with another one using MySQL functions?
- How can we combine multiple print statements per line in Python?
- 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?
Advertisements