SELECT userid,CASE WHEN inactivedays < 5 THEN 1 WHEN inactivedays < 8 THEN 2 WHEN inactivedays < 15 THEN 3 WHEN inactivedays < 31 THEN 4 ELSE 5 END AS inactivegroup FROM (SELECT userid,DATEDIFF(NOW(),updated) AS inactivedays FROM usertable ORDER BY DATEDIFF(NOW(),updated)) x
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.