UPDATE post SET pagetext = REPLACE(pagetext,'[align=center]',''); UPDATE post SET pagetext = REPLACE(pagetext,'[/align]','');