기존 악성 데이터 정리

-- 1. 먼저 악성 데이터 확인 (백업 목적)
SELECT id, short_url, comment, ip_address, created_at 
FROM comments 
WHERE short_url REGEXP '(SLEEP|WAITFOR|PG_SLEEP|SELECT.*FROM|UNION|OR [0-9]+=|XOR|sysdate)' 
   OR short_url LIKE '%&#%'
   OR comment REGEXP '(SLEEP|WAITFOR|PG_SLEEP|SELECT.*FROM|UNION|OR [0-9]+=)'
ORDER BY created_at DESC;

-- 2. 확인 후 악성 데이터 삭제
DELETE FROM comments 
WHERE short_url REGEXP '(SLEEP|WAITFOR|PG_SLEEP|SELECT.*FROM|UNION|OR [0-9]+=|XOR|sysdate)' 
   OR short_url LIKE '%&#%'
   OR comment REGEXP '(SLEEP|WAITFOR|PG_SLEEP|SELECT.*FROM|UNION|OR [0-9]+=)';

-- 3. 정리 결과 확인
SELECT COUNT(*) as remaining_comments FROM comments;