1242 – Subquery returns more than 1 row – mysql

MySQL gives me an error 1242 – Subquery returns more than 1 row when running
UPDATE wp_posts
SET wp_posts.post_content = concat((
SELECT wp_postmeta.meta_value
FROM wp_postmeta
[…]

See original post by invalid@example.com (vahing)