SELECT * FROM lf08v2_fahrraeder WHERE YEAR(kaufdatum) < 2007 OR YEAR(kaufdatum) > 2007;

SELECT * FROM lf08v2_fahrraeder WHERE YEAR(kaufdatum) <> 2007;

Ausgabe

Fahrradnummer	Kaufdatum
1	2008-06-22
2	2008-06-22
3	2006-10-11
4	2008-05-05
5	2008-05-05
7	2008-03-11
8	2008-03-10
9	2008-01-17
10	2008-05-27
11	2008-05-15
12	2008-05-05
15	2008-01-02
16	2008-05-16