5 MySQL function

Web Development

More than merely storing and retrieving data is possible with MySQL. Before retrieving or saving the data, we can also manipulate it. MySQL Functions can help with it. Simply put, functions are segments of code that carry out certain tasks and then produce an outcome. Other functions do not accept parameters, whereas some functions do.

1. CONCAT():

This function concatenates two or more strings and returns the result

SELECT CONCAT('Hello', ' ', 'World'); -- Output: 'Hello World'

2. SUBSTRING():

This function extracts a substring from a string.

SELECT SUBSTRING('Hello World', 1, 5); -- Output: 'Hello'

3. LOWER():

This function returns a string with all characters in lowercase.

SELECT LOWER('Hello World'); -- Output: 'hello world'

4. UPPER():

This function returns a string with all characters in uppercase.

SELECT UPPER('Hello World'); -- Output: 'HELLO WORLD'

5. DATE_FORMAT():

This function formats a date according to a specified format.Note: The NOW() function returns the current date and time in MySQL. The format '%Y-%m-%d %H:%i:%s' is used to format the date as YYYY-MM-DD HH:MM:SS

SELECT DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%s'); -- Output: '2023-03-23 12:34:56'

To Top