Update SQL query for multiple values [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 11 years ago.

Improve this question

I want to write migrate script for my word-press blog in mysql with single statement if possible

here is sudo code what i want to do.

SELECT post_id, meta_value FROM wp_postmeta WHERE meta_key =  'product' as olddata;
foreach {
UPDATE wp_postmeta SET meta_value=olddata.post_id WHERE meta_key = 'myslug_product' AND meta_value = olddata.meta_value 
}

I know it can be done with any programming language. But i want sql solution.

yes i did found they fires two or there times update depending on where condition. — Spock
– Spock, Commented Nov 6, 2014 at 14:09
If you find an answer, then simply delete your question. Or it may be further downvoted or even marked as duplicate and auto-closed via review-queue. If you lack something, then clearly describe your intention and what problem you can't fix yourself. — Sinatr
– Sinatr, Commented Nov 6, 2014 at 14:35

Abercrombieande · Accepted Answer · 2014-11-06 14:01:20Z

1

Why use "for each" when you can do an update join. In my opinion it is a lot cleaner.

UPDATE wp_postmeta 
INNER JOIN wp_postmeta olddata 
ON meta_value = olddata.meta_value and
   olddata.meta_key =  'product'
SET meta_value=olddata.post_id
WHERE meta_key = 'myslug_product'

answered Nov 6, 2014 at 14:01

Abercrombieande

7196 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update SQL query for multiple values [closed]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related