SELECT WHERE IN problem?

[winky3d]

Using mySQL 4.1

This returns the correct count:

SQL:
SELECT COUNT(*) FROM "._MY_TABLE." WHERE ts 
BETWEEN '2007-01-01 00:00:00' AND '2008-01-01 00:00:00' 
AND pcode IN ('aew', 'sdd')

This ignores the IN clause and returns all rows between the dates:

SQL:
SELECT email, l_name, state FROM "._MY_TABLE." WHERE ts 
BETWEEN '2007-01-01 00:00:00' AND '2008-01-01 00:00:00' 
AND pcode IN ('aew', 'sdd')

Suggestions?

thx.