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
  WHERE wp_postmeta.post_id = wp_posts.ID && wp_postmeta.meta_key ="mabp_description"),'<center><a href=[php snippet=1] rel="nofollow"><img src="',(
  SELECT wp_postmeta.meta_value
  FROM wp_postmeta
  WHERE wp_postmeta.post_id = wp_posts.ID && wp_postmeta.meta_key ="mabp_thumbnail_url"),'" alt="[php snippet=2]" title="[php snippet=2]"></a></center>');

Code (markup):

According to http://stackoverflow.com/questions/12597620/1242-subquery-returns-more-than-1-row-mysql this can be solved with an IN statement, but I don't know how to do that for the above code.

Your advice is really aprreciated!

 

You can't solve your problem like this since you cannot rely on the fact that query 1 returns the same amount of records as query 2, and your DBRMS does not know which records to couple. You should perform a query for each record that you are trying to update in a loop => you need a script

hope this helps,

 

You sub-queries are bring back more then 1 row and based on what you are doing, it's not expecting more then 1 row. You can limit it to 1 row and you won't get the error, but I'm not sure you'll get the results you want.

UPDATE wp_posts
SET wp_posts.post_content = concat((
SELECT wp_postmeta.meta_value
FROM wp_postmeta
WHERE wp_postmeta.post_id = wp_posts.ID && wp_postmeta.meta_key ="mabp_description" limit 1),'<center><a href=[php snippet=1] rel="nofollow"><img src="',(
SELECT wp_postmeta.meta_value
FROM wp_postmeta
WHERE wp_postmeta.post_id = wp_posts.ID && wp_postmeta.meta_key ="mabp_thumbnail_url" limit 1),'" alt="[php snippet=2]" title="[php snippet=2]"></a></center>');

Code (markup):