I have a very similar question to this: Custom Fields Bulk Edit

I would like to edit ALL of the data inside a custom field but instead of replacing values I would like to instead add an attribute to the custom field on each page. Example:

This is an existing shortcode [idx-listings linkid="387056" count="6"] I now want to add an attribute to look like this: [idx-listings linkid="387056" count="6" showlargerphotos="true"] Is there a way of bulk apending the showlargerphotos attribute inside the existing shortcode without affecting the rest of the string?

Here is the custom field in the wp_postmeta table

I have a very similar question to this: Custom Fields Bulk Edit

I would like to edit ALL of the data inside a custom field but instead of replacing values I would like to instead add an attribute to the custom field on each page. Example:

This is an existing shortcode [idx-listings linkid="387056" count="6"] I now want to add an attribute to look like this: [idx-listings linkid="387056" count="6" showlargerphotos="true"] Is there a way of bulk apending the showlargerphotos attribute inside the existing shortcode without affecting the rest of the string?

Here is the custom field in the wp_postmeta table

• plugins
• mysql

Share Improve this question edited Dec 5, 2019 at 21:37 Chris asked Dec 5, 2019 at 20:57 ChrisChris 11744 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

In phpMyAdmin:

update wp_postmeta set meta_value =
replace(meta_value,'[idx-listings','[idx-listings showlargerphotos="true"');

As long as you've always typed the shortcode starting with [idx-listings and not, say, [ idx-listings, this will add your new attribute everywhere the shortcode has been used.