Title: Mysql And WordPress
Last modified: August 20, 2016

---

# Mysql And WordPress

 *  [StudioWorks](https://wordpress.org/support/users/studioworks/)
 * (@studioworks)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/mysql-and-wordpress/)
 * Hello,
 * I have a less than ordinary problem and can’t solve it without manually editing
   posts ( and there are around 2,000 of them ).
 * Let me explain.
 * I have around 2,000 posts all containing <span> text </span> in the post content.
   That piece of text between the span tags is different on all posts.
 * What I want to know is if there is a way to automatically find and replace anything
   between <span> and </span> in mysql. Basically, find and replace everything between
   two html tags. It would be easy to find and replace, for example, <span> my title
   </span> but since the text between the span tags is different for all posts this
   solution does not work for me..
 * Any help will be greatly appreciated..

Viewing 1 replies (of 1 total)

 *  [vtxyzzy](https://wordpress.org/support/users/vtxyzzy/)
 * (@vtxyzzy)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/mysql-and-wordpress/#post-2735123)
 * I think your best bet would be to export the table and use a text editor with
   regular expression capability to make the changes. Then import the modified sql
   back into the table.

Viewing 1 replies (of 1 total)

The topic ‘Mysql And WordPress’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [vtxyzzy](https://wordpress.org/support/users/vtxyzzy/)
 * Last activity: [14 years, 3 months ago](https://wordpress.org/support/topic/mysql-and-wordpress/#post-2735123)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics