how to concat two columns in sql?

php, Mysql, Mysqli Leave a comment

MySQL CONCAT() Function

To concatenate two columns in SQL, you can use the CONCAT function. The syntax is as follows:

SELECT CONCAT(column1, column2) AS new_column_name FROM table_name;

In the above syntax, column1 and column2 are the names of the columns you want to concatenate, new_column_name is the name of the new column that will contain the concatenated result, and table_name is the name of the table containing the columns.

For example, if you have a table named employees with columns first_name and last_name, you can concatenate them into a new column called full_name like this:

SELECT CONCAT(first_name, ' ', last_name) AS full_name FROM employees;

This will create a new column called full_name that contains the concatenated values of first_name and last_name, separated by a space.

Note that the CONCAT function can be used to concatenate more than two columns by simply adding additional column names as arguments.

Related posts:

  1. sql concatenate two columns – How to Concat First Name and Last Name in Laravel?
  2. Laravel 6 CONCAT Multiple Columns with example
  3. how to concat two columns in sql?
  4. Laravel 6 concatenate Multiple Columns with Example
  5. add column after another column in mysql
  6. How To Create Image Hover Overlay Effects?
  7. update multiple columns sql
  8. laravel search query – How to Search First Name and Last Name in Laravel Query?
  9. Transparent black color and Opacity Color Codes
Also Read This 👉   Simple Laravel Contact Us Form With Email Example