You’ll only need to run it once, but this should get all your posts, and then loop through them and update the meta.
add_action('admin_init', 'deleteCommaDB');
function deleteCommaDB(){
// The Query
$args = array ( 'posts_per_page' => -1 );
$the_query = new WP_Query( $args );
// The Loop
while ( $the_query->have_posts() ) :
$the_query->the_post();
$price_key = 'prijs';
$getPrice = get_post_meta( get_the_ID(), $price_key, true);
$newPrice = str_replace(array(','), '', $getPrice);
update_post_meta(get_the_ID(), $price_key, $newPrice);
endwhile;
}
Your function runs only when a post is inserted. You might want to consider running on save_post
and sanitizing the $_POST
input in the first place.
Related Posts:
- Custom post meta field effect on the performance on the post
- Difference between meta keys with _ and without _ [duplicate]
- Orderby meta_value only returns posts that have existing meta_key
- How to enable revisions for post meta data?
- Best way to programmatically remove a category/term from a post
- When using add_post_meta and update_post_meta, is there any way to give the individual arrays keys?
- Storing meta fields multiple times OR once with multi dimensional array?
- display specific custom fields
- passing argument to get_template_part() or a better way to code
- Is it possible to store arrays in a custom field?
- Multiple meta values for same meta_key adding on “Preview Changes” hit but not on saving or updating post
- importing data from non-wordpress mysql db
- Create meta boxes that don’t show in custom fields
- Transients vs CRON +Custom Fields: Caching Data Per Post
- Unable to save datetime custom meta field using update_post_meta() function
- Create custom field on post draft or publish?
- get_post_meta fields don’t show up on posts page
- copy attachments to another post type and change attachment url
- Cannot edit post meta fields with rest API
- Copying Custom Meta Values from existing post to a duplicate post
- Add a post meta key and value only if it does not exist on the post
- Move value of one custom field to another
- Order posts according to user defined order for meta values?
- Displaying posts with only upcoming dates according their custom field date value
- Get a post_id where meta_value equals something in a serialized meta_value field
- How to save a ToggleControl value in a meta field?
- Author Page Custom Query WHERE author OR [post meta value] OR [post meta value]
- MySQL query to set wp_postmeta using term_taxonomy_id value
- How to Validate Post Meta type/extension (Video File Image File etc)
- Custom Meta Box not Saving in Posts with Gutenberg Editor
- How can I sort homepage by a meta value?
- Get specific custom field keys from a post and put into an array
- How to wrap meta values seperated by comma in ? [closed]
- Bulk remove post meta
- How to create html block to display extra information on woocommerce single product page
- Create Multiple File Upload Metabox in WordPress
- filtering custom post types via meta data drop down
- Run a check for multiple meta key values
- If meta key exists in get posts function otherwise create it
- WordPress Rest API to call page data associate with custom meta
- How do I Implement Atomic Update of Post Metadata?
- Hide custom meta data if empty
- How do I have WP_Query match posts based on search parameter OR meta fields? (rather than search parameters AND meta fields)?
- Button inside Custom Meta Box triggering the Update Button
- Why is my Custom Meta Box Field Inputs NOT saving?
- Get registered custom fields or post meta even if empty
- How to load an assets based on custom field value?
- Custom WP_Query for WordPress Search Results with meta_query
- How can you include custom post meta in search without calling each key?
- shortcode in a custom metabox
- Can I access a post meta field before the loop?
- wrap text around custom fields array
- How can I modify RSS item titles to be either the title or a custom meta field?
- Avoiding ACF get_field and returning to core WordPress function
- Problem with saving large amount of data in postmeta/usermeta
- How to get posts with a metadata numeric key greater than X?
- Get all the posts where meta field with multiple choice has several values checked
- Move Title and the Content WYSIWYG editor position
- How do i get the attached images with custom value checked?
- Update post meta custom field using block editor
- Get custom fields without _edit_last, _edit_lock, _wp_page_template and _visual-subtitle
- Display posts with empty custom field
- Why am I getting a “Call to member function format() on a non-object” error?
- Can’t Output get_post_meta?
- If metabox has content display content
- Modify custom field from front end
- Footnotes in custom fields
- Create a new custom field for all posts based on current custom field
- Display Meta Data with HTML?
- wordpress get_post_meta / the_meta to output custom field value
- Custom Query: query by post custom meta data
- Group Posts By Custom Meta Value: Date
- Meta field bulk editing no longer working in WP 6.0 [closed]
- update_post_meta not working well
- Set class if a meta value is set within post archive
- How to add a post’s view count into the WordPress API response
- Adding Facebook’s image and meta description retrieval capabilities to a WordPress post
- Can’t set custom meta fields for a post
- Allow HTML in Custom Metabox area
- Custom field metabox not showing in back-end
- Save, update, get and sanitize post meta as HTML not plain
- Saved Post Meta Array Returns as String
- Query Multiple meta
- Query Posts based on custom field value
- Problem saving meta data
- Query postmeta values, and return multiple post_titles for common meta value
- When post is updated, custom metadata in text area field is overwritten
- change attachment custom field onChange event
- Media Attachment Custom Meta Fields not saving in Media Uploader when using jQuery UI Autocomplete
- Custom Field: Display only if a specific key is selected outside the loop
- When editing a post with a custom meta box the values aren’t displaying correctly
- add_post_meta insert null value into Database
- Make Custom Fields Public in JSON – API
- Retrieving custom field as shortcode
- Order by a meta field in query loop
- save all acf options in one meta_value [closed]
- How to add new Metadata options (Date, Author, etc.) for Posts?
- WP Query Args – search by meta_key or title
- Saving multiple custom meta box fields
- Search for meta_query does not return any result if combined with title