MYSQL to change content in wordpress post meta fields

How to use substr in MYSQL to change content in wordpress post meta fields

Following sample MYSQL query is used to update wordpress post meta field using substr function
update wp_postmeta set price = substr(price,2) where meta_key = 'aspfwpnewprice'
Sign In or Register to comment.