SQL Collect Values from different rows and update the new one

I have a WordPress database. in postmeta table we have 3 different values for each post. we update our theme 3 times and in each time the post count is different from each other. I want to make this; there are values in one table in different rows:

post id 10 value 1: better-views-count 3455
post id 10 value 2: post_stats 522
post id 10 value 3: post_views_count 52

I want to sum the three and update the result post_views_count.

How I can do it and what the sql should I use it?

I think there is no option to do it with SQL fol 1000 post it should be a php code. But I cannot image the sql which I should use it.

Read more here: SQL Collect Values from different rows and update the new one

Leave a Reply

Your email address will not be published. Required fields are marked *