Mysql query question

[no_maam]

Hi guys!
How do i append to each record some text?
i tryed: "UPDATE table SET name=name+'_text' , but that does'nt work.
Example:

John to john_uk
Mike to mike_uk

Thanks!!

[LarsLai]

$name .= "_text";
UPDATE table SET name='$name'

[Weedpacket]

"UPDATE table SET name='{$name}_text'"

"UPDATE table SET name='".$name."_text'"

[no_maam]

Ok, now it works! Thanks!😃 😃

[xblue]

hey, maybe I got this completely wrong, but I unserstood from your first post that you were trying to append something via sql (without actually knowing the current values, i.e. not select query to get them first).

My approach would have been

UPDATE table SET name=CONCAT(name, '_text')

which seemed to work fine - but glad you seem to have resolved it anyway, one way or the other.