Program Web
스팸 댓글 지워보기;;
HisPark
2007. 9. 28. 00:08
//댓글삭제
delete from `zetyx_board_comment_His_Programming` where `memo` LIKE '%http%';
delete from `zetyx_board_comment_His_Music` where `memo` LIKE '%http%';
//카운트 셋팅
UPDATE zetyx_board_His_Programming SET `total_comment` = 0 WHERE `total_comment` >= 4;
UPDATE zetyx_board_His_Music SET `total_comment` = 0 WHERE `total_comment` >= 4;
delete from `zetyx_board_comment_His_Programming` where `memo` LIKE '%http%';
delete from `zetyx_board_comment_His_Music` where `memo` LIKE '%http%';
//카운트 셋팅
UPDATE zetyx_board_His_Programming SET `total_comment` = 0 WHERE `total_comment` >= 4;
UPDATE zetyx_board_His_Music SET `total_comment` = 0 WHERE `total_comment` >= 4;