Mysql update append?

is there a way to directly append in a single mysql update query? – without first fetching the data?

Can you explain more detailly, please?

Yes…CONCAT for strings, DATE_ADD/DATE_SUB for dates, straight arithmetic operators for numbers. You can even do conditional logic within queries.

As an example…

UPDATE table SET field = CONCAT( field, ’ this is appended’ ) WHERE id = 7;

… like magic… ok, now to replace all my mysql_fetch, concat in php, mysql_send code with the wonderful concat() function