adding new text to the field

[jansky]

greetings

how can i concat string or text to my fields (R.title)

eg: R.title =' hello world'
after updating
then it will be
R.title = 'hello world for username '

here is the query

update roster R join
(select concat (' For ', username)) as addedtitle from user
where id = 2)
as U
set R.title = U.addedtitle // This should concat the value R.title + U.addedtitle

where
R.id = 1

[sneakyimp]

update roster R set R.title=CONCAT(R.title, ' For ', R.username)

try that? Be sure to back up your db table before you run it.

[jansky]

thanks
but that only work with out the 'select statement condition

eg: update table set name = concat(field, ' hello')

but not in

update table A join
(selec tbla balh blah where ) as b
set a.field = concat( b.field, ' or whatever) /// this not working

where a.field =

[sneakyimp]

ah right...didn't see user table in there. I'm not sure you can do an update with a join? I'm not really sure how you are planning to join your user table to your roster table. Do they share an id field? Do you want to update the entire table?

[jansky]

yes definitely you can update select join statement at same time

[johanafm]

UPDATE roster, user
SET roster.title = CONCAT(roster.title, ' for ', user.username)
WHERE roster.uid = user.id