php - 将值插入现有值 MySQL

Question

假设我有这张 table 。

 ID  Message

 1   Jack went to the park.
 2   Jamie went to the store.
 3   Lucy finished school.

如何在不完全覆盖现有值的情况下将值批量插入到 Message 列中？

例如

 ID  Message

 1   Jack went to the park **at 3pm**.
 2   Jamie went to the store **at 3pm**.
 3   Lucy finished school **at 3pm**.

我知道我可以通过 PHP 检索值，然后通过数组/循环将附加值重新插入它们，但我希望通过 PhpMyAdmin 纯粹使用 MySQL 来完成此操作。

Answer 1

UPDATE `table`
   SET `Message` = CONCAT(`Message`, " at 3pm")
 WHERE 1;