How to prepend a string to a column value in MySQL

Question

I need a SQL update statement for updating a particular field of all the rows with a string  test  to be added in the front of the existing value   For example  if the existing value is  try  it should become  testtry

User · Accepted Answer

You can use the CONCAT function to do that:

UPDATE tbl SET col=CONCAT('test',col);

If you want to get cleverer and only update columns which don't already have test prepended, try

UPDATE tbl SET col=CONCAT('test',col)
WHERE col NOT LIKE 'test%';

User · Answer

UPDATE tablename SET fieldname   CONCAT  test   fieldname   WHERE

User · Answer

UPDATE table name SET Column1   CONCAT  newtring   table name Column1  where 1 UPDATE table name SET Column1   CONCAT  newtring   table name Column2  where 1 UPDATE table name SET Column1   CONCAT  newtring   table name Column2   newtring2   where 1   We can concat same column or also other column of the table

User · Answer

That s a simple one  UPDATE YourTable SET YourColumn   CONCAT  prependedString   YourColumn

User · Answer

Many string update functions in MySQL seems to be working like this  If one argument is null  then concatenation or other functions return null too  So  to update a field with null value  first set it to a non-null value  such as     For example   update table set field    where field is null  update table set field concat field   append

[mysql] How to prepend a string to a column value in MySQL?

Examples related to mysql

Examples related to sql-update