hmm., please try :
UPDATE `mybb_posts` SET `message` = REPLACE (`message`, '[INDENT]', '') WHERE `message` LIKE '%[[]INDENT]%';