XF 1.4 help find and replace from db

[jamalfree]

hi
i want to replace many codes from db with reg exp for wining time and effort please help some codes
for example
[FONT=Verdana, Arial, Helvetica, sans-serif]
i want any code begin with [FONT and endedd with ] shoud remove it

and
any code begin [COLOR endedd with ] remove it


sql

UPDATE `xf_post` SET message = replace( message, '', '' ) ;
UPDATE `xf_post` SET message = replace( message, '[COLOR=#003366', '' ) ;[/QUOTE]

 

[jamalfree]

and

[table1="width:95%;background-image:url('[url]http://www.site.com/mwaextraedit2/backgrounds/170.gif');background-color:white;[/url]"]
[table1="width:95%;background-image:url('[url]http://www.site.com/mwaextraedit2/backgrounds/170.gif');background-color:white;[/url]"]

and any code begin with
[table1
ended with ]
shoud remov it

 

[jamalfree]

now i use this addon https://xenforo.com/community/resources/post-content-find-replace.1549/ but i dont know what i write in fields