mysql - How to add to string a new string -
i have database products. need add name of products string. example: product name "abc1", "abc2", "abc3" new products name: "super abc1", "super abc2", "super abc3"
use mysql's concat().
if want update
:
update tablename set column=concat('super ', column);
you can add where
clause .
Comments
Post a Comment