Mysql update menu_order problem

Question

I trying to update menu_order if post_type product not have _thumbnail... Tried:

UPDATE phiz_posts SET menu_order = 1 WHERE ID IN (SELECT ID FROM phiz_posts LEFT JOIN phiz_postmeta ON phiz_posts.ID = phiz_postmeta.post_id AND phiz_postmeta.meta_key = '_thumbnail_id' WHERE post_type='product' AND phiz_postmeta.post_id IS NULL)

Error: You can't specify target table 'phiz_posts' for update in FROM clause

This sql return the list of product ID without _thumbnail correctly:

SELECT ID FROM phiz_posts LEFT JOIN phiz_postmeta ON phiz_posts.ID = phiz_postmeta.post_id AND phiz_postmeta.meta_key = '_thumbnail_id' WHERE post_type='product' AND phiz_postmeta.post_id IS NULL

How can change this ?

Best,

ilanb · Accepted Answer · 2020-04-30 18:54:50Z

0

UPDATE phiz_posts p SET menu_order = 1 WHERE ID NOT IN (SELECT post_id FROM phiz_postmeta WHERE meta_key = '_thumbnail_id') 
AND post_type = 'product' 
AND post_status = 'publish'

answered Apr 30, 2020 at 18:54

ilanb

933 silver badges12 bronze badges

Add a comment |

Stack Exchange Network

Mysql update menu_order problem

1 Answer 1

Your Answer

Hot Network Questions

Mysql update menu_order problem

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions