Title: I need an SQL query to remove Adsense Code
Last modified: August 20, 2016

---

# I need an SQL query to remove Adsense Code

 *  [ringolingo](https://wordpress.org/support/users/ringolingo/)
 * (@ringolingo)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/i-need-an-sql-query-to-remove-adsense-code/)
 * After importing from Blogger, using the Blogger Importer plugin after a fresh
   install, for some strange reason, my new database got populated with Adsense 
   code at the end of every post. I checked the publisher ID, and it’s mine. My 
   Blogger account is tied to my Adsense account, so maybe that explains the presence
   of that unwanted code. I don’t know.
 * So, anyways. I tried to run an SQL query in PhpMyAdmin, to remove that code, 
   but i got an error. Then I tried to use the Search & Replace plugin, but it returned
   nothing.
 * The Adsense Code is a long string, with multiple carriage returns, and I don’t
   know how to deal with it.
 * This is the Adsense code I’m talking about:
 * [http://pastebin.com/6ZuVKxX7](http://pastebin.com/6ZuVKxX7)

The topic ‘I need an SQL query to remove Adsense Code’ is closed to new replies.

## Tags

 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [query](https://wordpress.org/support/topic-tag/query/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [ringolingo](https://wordpress.org/support/users/ringolingo/)
 * Last activity: [14 years, 3 months ago](https://wordpress.org/support/topic/i-need-an-sql-query-to-remove-adsense-code/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics