
- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
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 Articles
- 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?
- 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 create recursive functions in Python?
- How can we use group functions with non-group fields in MySQL SELECT query?
- Can we combine GridLayout and BorderLayout in Java?
- How can we combine multiple print statements per line in Python?
- How can we see only the list of stored functions in a particular MySQL database?
- How we can store Python functions in a Sqlite table?
- How can we use the output of LTRIM() and RTRIM() functions to update MySQL table?
- How can we see the list of stored procedures and stored functions in a particular MySQL database?

Advertisements