MySQL MOD Abfage?

[Rolf]

Okay,

SELECT id, wert1,  
MOD( ( TO_DAYS( NOW() ) - TO_DAYS( td.create_date) ), 3 ) AS mymod1  
FROM data1 AS td  
WHERE  
MOD( ( TO_DAYS( NOW() ) - TO_DAYS( td.create_date) ) , 3) = 0;

Und was gefällt Dir an:

+----+--------+--------+  
| id | wert1  | mymod1 |  
+----+--------+--------+  
|  2 | test_3 |      0 |  
+----+--------+--------+  
1 row in set (0.00 sec)

nun nicht ... ?

m.b.G. Rolf