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

Popular posts from this blog

basic authentication with http post params android -

vb.net - Virtual Keyboard commands -

css - Firefox for ubuntu renders wrong colors -