How To Concat First Name and Last Name In MySQL?

Jan 20, 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