UPDATE vb3_post SET pagetext = REPLACE(pagetext,'
    ','[list=1]'); UPDATE vb3_post SET pagetext = REPLACE(pagetext,'',''); UPDATE vb3_post SET pagetext = REPLACE(pagetext,'
','[/list]');