How to Update Column with CONCAT string from another Column in MySQL

Last Updated : November 25, 2021Last Updated : September 7, 2023By TechArise Team

We can append a string of data to an existing data of a field by using CONCAT function of MySQL. In this tutorial, We will show you How to Update a Column with a CONCAT string from another Column in MySQL.

Also Read: How to Update CSS Content Property Dynamically

You can do this:

    UPDATE employee SET email=concat(first_name, '@techarise.com');

1	UPDATE employee SET email=concat(first_name, '@techarise.com');

Also Read :How to Open URL in Same Window and Tab using JavaScript