mySQL Select

[Anon]

I am quite new to mySQL I have a quick question..

basically I have a query like: "SELECT Graduation_Year FROM members WHERE 1 AND Graduation_Year >2002 ORDER BY Graduation_Year ASC LIMIT 0, 30"

is it possible to search for 'Graduation_Year'>2002 but <2004?

Any help is greatly appreaciated

[wurstbrot]

Yes, that's quite simple:

...WHERE 1 AND Graduation_Year >2002 AND Graduation_Year <2004....

That must work in mySQL (in MSSQL, it works)

Wurstbrot

[Anon]

Ah thanks I put ' instead of ` (agian) thats why it didnt work earlier. (:

Once agian thanks for the quick responce.

/toxic_acid