Search

'전체 글'에 해당되는 글 113건

  1. 2007.09.28 스팸 댓글 지워보기;;

스팸 댓글 지워보기;;

Program Web 2007. 9. 28. 00:08 Posted by HisPark
//댓글삭제
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;