This method can be used to concat strings into the same column.
UPDATE `tbl_name` SET `column_1` =CONCAT( 'string',`column_1`)
If you want to update another column with concat another column, use this
UPDATE `tbl_name` SET `column_1` =CONCAT( 'string',`column_2`)
No comments:
Post a Comment