How To Concat First Name and Last Name In MySQL?

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...