Title: urldecode post content and link problem
Last modified: August 21, 2016

---

# urldecode post content and link problem

 *  [rd801503](https://wordpress.org/support/users/rd801503/)
 * (@rd801503)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/urldecode-post-content-and-link-problem/)
 * i am have imported from blogger to wordpress
 * i have some issues
 * 1.> the link in the post_contents are like this
 * > some content here
 * `"<a href="www.sitecounter.com/?key=something&link=www.myblog.blogspot.com">link
   </a>`
 * >  some content here
 * here sitecounter.com maintains a link click counter
 * i have to remove it to
 * `"<a href="www.sitecounter.com/?key=something&link=www.myblog.blogspot.com">link
   </a>`
 * with no counter here
 * AND
 * 2.> urldecode the link in the post. , as some link get problematic with %2f@3f
   like structure

Viewing 1 replies (of 1 total)

 *  [David Choi](https://wordpress.org/support/users/wpthemes777/)
 * (@wpthemes777)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/urldecode-post-content-and-link-problem/#post-3775602)
 * If the links are not imported properly, then you can run MySQL find and replace
   SQL to correct them
 * update [table_name] set [field_name] = replace([field_name],'[string_to_find]’,'[
   string_to_replace]’);

Viewing 1 replies (of 1 total)

The topic ‘urldecode post content and link problem’ is closed to new replies.

## Tags

 * [problem](https://wordpress.org/support/topic-tag/problem/)
 * [string](https://wordpress.org/support/topic-tag/string/)

 * In: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/)
 * 1 reply
 * 2 participants
 * Last reply from: [David Choi](https://wordpress.org/support/users/wpthemes777/)
 * Last activity: [13 years, 2 months ago](https://wordpress.org/support/topic/urldecode-post-content-and-link-problem/#post-3775602)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics