Mysql Update

[Anon]

is there a MySQL query that updates a record that just aded a string on to the end of a existing record.

say i've got:

jim|blue|five

i do a single query to add 'thing' to column3

so the record is know:

jim|blue|fivething

Can i do this in one query?

thanks

[[deleted]]

Read the MYSQL manual about the string functions.

UPDATE table
SET field = concat(field, 'string')
WHERE foo=bar;

Note: it's usually not a good idea to use delimited data in a database field; for ex: what if you wanted to add some characters to the second word in the string?