Need help with simple MySQL query

Question

I have a table with 4 values, meta_id, post_id, meta_key and meta_value, and I want to change all meta_values found as "yes" to "si" when the meta_key is stock_available... how do I do this?. I cannot even retrieve the rows at this point...I'm trying with something like this.

SELECT `meta_value` FROM `wp_postmeta` WHERE `meta_key` AND `meta_value` = 'yes'

Could I have some help?

EDIT: I had forgotten the meta_key...

SELECT * FROM `wp_postmeta` WHERE `meta_key` = 'stock_available' AND `meta_value` =  yes'

So I retrieve these... btu how do I update them?

You must provide a condition for 'meta_key', for example SELECT meta_value FROM wp_postmeta WHERE meta_key = 'somekey' AND meta_value = 'yes' — acw
– acw, Commented Jul 19, 2011 at 15:23

Adam Batkin · Accepted Answer · 2011-07-19 15:21:52Z

1

You need to use the SQL UPDATE statement:

UPDATE wp_postmeta SET meta_value = 'si' WHERE meta_value = 'yes' AND meta_key = 'stock_available'

Before you do that, run this SELECT to make sure that you are going to be updating the correct rows:

SELECT * FROM wp_postmeta WHERE meta_value = 'yes' AND meta_key = 'stock_available'

answered Jul 19, 2011 at 15:21

Adam Batkin

53.3k9 gold badges128 silver badges115 bronze badges

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

1 Comment

la_f0ka Over a year ago

that was it, thanks a lot... I need 11 minutes to accept the answer. I'llbe back then

Joe Stefanelli · Accepted Answer · 2011-07-19 15:22:28Z

1

UPDATE wp_postmeta
    SET meta_value = 'si'
    WHERE meta_key = 'stock_available'
        AND meta_value = 'yes';

answered Jul 19, 2011 at 15:22

Joe Stefanelli

136k21 gold badges243 silver badges241 bronze badges

Collectives™ on Stack Overflow

Need help with simple MySQL query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related