The custom field is "price" : and I am trying to update all the values by 20% (that is .20*price) .
I know all the custom fields are stored at wp_postmeta table
The field name which in this case is "price" is stored at the meta_key column
The value if the "price" is stored under meta_value column
so what I am trying to do is increase the value each row of meta_value column where the meta_key has the value price
I am attaching an screenshot for better explanation
This post has been edited by eddywebs: 14 March 2010 - 09:15 PM