Spam identification for SPIP 3

SELECT.sql

SELECT auteur, email_auteur, LEFT(texte, 50) 
FROM spip_forum 
WHERE LEFT(texte, 20) LIKE '%http%' 
AND statut <> 'spam'
ORDER BY maj DESC;

UPDATE.sql

UPDATE spip_forum 
SET statut='spam' 
WHERE LEFT(texte, 20) LIKE '%http%'
AND statut <> 'spam';