How to Remove BB Code from Thread Post

[Nirjonadda]

How to remove BB Codes tags From post ? ALL [HIDE] tags it's created.Please any one can post the SQL Code for remove the HIDE Code? I want to Completely remove the Tag HIDE Code, How i can do ?

Seven different BBCode:

[HIDE-REPLY]
[HIDE-POSTS]
[HIDE-THANKS]
[HIDE-REPLY-THANKS]
[SHOWTOGROUPS]
[STG]
[HIDE]

[Seven Skins]

Run this query after making DB backup.
Use it at your own risk.

UPDATE post SET pagetext = REPLACE(pagetext,'[HIDE-REPLY]','');
UPDATE post SET pagetext = REPLACE(pagetext,'[HIDE-POSTS]','');
UPDATE post SET pagetext = REPLACE(pagetext,'[HIDE-THANKS]','');
UPDATE post SET pagetext = REPLACE(pagetext,'[HIDE-REPLY-THANKS]','');
UPDATE post SET pagetext = REPLACE(pagetext,'[SHOWTOGROUPS]','');
UPDATE post SET pagetext = REPLACE(pagetext,'[STG]','');
UPDATE post SET pagetext = REPLACE(pagetext,'[HIDE]','');