ASSURE OU CRAINT ?

Erreur SQL !
SELECT COUNT(*) AS total FROM alias WHERE alias = "kevadams";