Title: Batch set custom field
Last modified: August 18, 2016

---

# Batch set custom field

 *  [hammerikaner](https://wordpress.org/support/users/hammerikaner/)
 * (@hammerikaner)
 * [19 years, 6 months ago](https://wordpress.org/support/topic/batch-set-custom-field/)
 * I need to batch set every one of my posts to have a certain custom field set 
   for them. The field would be ‘post_level’ to restrict access to every one of 
   my archived posts to, say, level 2.
 * Can someone please tell me what I would have to run in mysql to accomplish this?

The topic ‘Batch set custom field’ is closed to new replies.

## Tags

 * [batch](https://wordpress.org/support/topic-tag/batch/)
 * [customfield](https://wordpress.org/support/topic-tag/customfield/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [postlevels](https://wordpress.org/support/topic-tag/postlevels/)

 * 0 replies
 * 1 participant
 * Last reply from: [hammerikaner](https://wordpress.org/support/users/hammerikaner/)
 * Last activity: [19 years, 6 months ago](https://wordpress.org/support/topic/batch-set-custom-field/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics