Title: create a SQL script that edits a POSTS custom field value HELP
Last modified: August 19, 2016

---

# create a SQL script that edits a POSTS custom field value HELP

 *  [marcfolio](https://wordpress.org/support/users/marcfolio/)
 * (@marcfolio)
 * [17 years, 3 months ago](https://wordpress.org/support/topic/create-a-sql-script-that-edits-a-posts-custom-field-value-help/)
 * I need a way to quickly edit a value of a customField. I’m envisioning a php 
   script I can push the post title to and change the customfield’s value. So Say
   I have a post “hello kity” and and it has a custom field of “amount” with the
   value of “20” and I want to change the value from “20” to “19”?
 * Is there anyway to do that? Please help.

Viewing 1 replies (of 1 total)

 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [17 years, 3 months ago](https://wordpress.org/support/topic/create-a-sql-script-that-edits-a-posts-custom-field-value-help/#post-1017519)
 * Is that needed to change all posts that have the custom field of “amount” and
   a value of “20”?
 * Can’t you do that in [phpMyAdmin](http://codex.wordpress.org/phpMyAdmin)?
 * Always backup database before beginning such an excercise.

Viewing 1 replies (of 1 total)

The topic ‘create a SQL script that edits a POSTS custom field value HELP’ is closed
to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [MichaelH](https://wordpress.org/support/users/michaelh/)
 * Last activity: [17 years, 3 months ago](https://wordpress.org/support/topic/create-a-sql-script-that-edits-a-posts-custom-field-value-help/#post-1017519)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics