DELETE FROM `forums_PRIVATE_MESSAGE_POSTS` WHERE `POST_BODY` LIKE CONVERT( _utf8 'welcome to%' USING latin1 ); DELETE FROM `forums_PRIVATE_MESSAGE_TOPICS` WHERE `TOPIC_SUBJECT` LIKE CONVERT( _utf8 'welcome%' USING latin1 );