21-Jan-2022
.
Admin
Hello Friends,
This article will give you example of how to concat first name and last name in MySQL?. I explained simply about concat firstname and lastname in MySQL. This tutorial will give you simple concat first name and last name in MySQL.
In this post, You'll learn SQL query to concat first name and last name. I will show you use of concat first and last name MySQL with space.
Here i will give you many example first name and last name concatenate.
So let's see bellow solution:
Table: users
So, let's see bellow solution:
Solution SQL Query:
SELECT
id, CONCAT(first_name, ' ',last_name) as full_name, email, created_at
FROM `users`
Output:
I hope it will help you...
#MySQL