Replacing BB Codes...
 

Hello dear ...
Iam using vB 3.5.0 RC3 ...

While I was using from vB 3.0.0 To vB 3.0.7 ... I Installed hack called Magic Tools .. and It same as BB Codes ... But It has More ..

When I upgraded to vB 3.5.0 ... all previous codes has been look like CODES instead of what should be look like ... which is cause bad look for threads and posts ...

Now .. I want by using MYSQL ...
replace from :

To
[ center][/ center] >> without space between [ and c or / and c ...

for example :
UPDATE post SET pagetext=REPLACE(pagetext,'[poem ','[poem=');

Thanks ...