How To Search First Name and Last Name in MySQL?

Hi Friends,

I am going to explain you example of how to search first name and last name in MySQL? , You will learn how to get first name and last name in SQL query. I would like to how to get first name and last name. This article will give you simple example of get first name and last name from full name in MySQL.

We will use get search first name and last name MySQL. You can understand a concept of search first name and last name mysql.

You can see both example of how to search first name and last name use query.

Let's see bellow example:

Table: users

Solution SQL Query:

SELECT 
    id, CONCAT(first_name, ' ',last_name) as full_name, email, created_at FROM 
`users`
    WHERE CONCAT(first_name, ' ',last_name) LIKE 'Hardik Sav%'

Output:

I hope it will help you...