Appending data to end of field

[Anon]

I'm trying to add some data to a field in my MySQL database. What I want to do is change the field value to:-

fieldvalue = fieldvalue, $userid

but I can't figure out how to append data. Any clues?

The column is a LONGTEXT type.

Thanks!

[Anon]

You can use the concat function in Mysql.

e.g. update tab_nam set field_name = concat(field_name, "bit I want to add") where where condition.

http://www.mysql.com/doc/S/t/String_functions.html

Cheers

[Anon]

Works a treat! Thanks!!

--Rich

[vijay17877]

hi,

You can use the update query to get this done.

$sql= "Update tablename set fldvalue= '$userid';

hope this helps u in solving the problem.

Good Day

• vijay

Rich wrote:

I'm trying to add some data to a field in my MySQL database. What I want to do is change the field value to:-

fieldvalue = fieldvalue, $userid

but I can't figure out how to append data. Any clues?

The column is a LONGTEXT type.

Thanks!