MySQL query to strip quotes

[Syn9]

I'm interested in stripping quotes without removing the posts containing them. For example, in the xf_post table:

[QUOTE="USERNAME, post: #, member: #"]Random quoted text.[/QUOTE]

I'm aware of this addon that can delete posts containing quotes, but only want to strip quote tags including the content between them.

 

[pattycake2]

Can you give me an EXACT example of a string in a post that has what you want to strip?

 

[Syn9]

Thanks, as requested:

[QUOTE="Jack, post: 40, member: 12"]Thanks a lot [USER=7]@Moe[/USER].[/QUOTE]
You're welcome!

In the above example I'd be interested in stripping everything except the non-quoted text, specifically: You're welcome!

 

[Paul B]

You will need to use this add-on as the content between the tags is different in each case.

Post Content Find / Replace

This is a direct port of the original Post Content Find / Replace add-on for XF 1.x. You may wish to search the original resource discussion for solutions to common tasks performed with this add-on.

xenforo.com

 

[pattycake2]

Thanks, as requested:

[QUOTE="Jack, post: 40, member: 12"]Thanks a lot [USER=7]@Moe[/USER].[/QUOTE]
You're welcome!

In the above example I'd be interested in stripping everything except the non-quoted text, specifically: You're welcome!

Yep, Brogan is right - I misread your request and thought you wanted to strip quotes as in single quotes, double quotes, etc. not "quote tags"