Title: mysql db replace issue
Last modified: August 21, 2016

---

# mysql db replace issue

 *  [kicker](https://wordpress.org/support/users/kicker/)
 * (@kicker)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/mysql-db-replace-issue/)
 * I have 13000 articles and almost as many comments. I have had a gigantic fail
   with ADSENSE lately. Down 80%.
    I thought to try and remove all naughty words
   to see if it matters. I have an unmanaged dedicated server.
 * Using DB Manager, ADMINER and even the MYSQL on WEBMIN at the server I use the
   following code in SQL EXECUTE:
 * `UPDATE wp_posts SET post_content = REPLACE (post_content, 'shit', 'crap');`
 * I am told the syntax is correct, the results show:
    Query executed OK, 0 rows
   affected. (0.713 s)
 * Searching the site finds 95 instances before and after.
    The server looked into
   it for me and found nothing wrong with the DB or the SYNTAX but that is as far
   as they would go.
 * Any help in the matter would be much appreciated. I also have 500 assholes to
   rid of! 🙂
    Thanx kicker rackjite.com

The topic ‘mysql db replace issue’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [kicker](https://wordpress.org/support/users/kicker/)
 * Last activity: [12 years, 1 month ago](https://wordpress.org/support/topic/mysql-db-replace-issue/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics