That query seems to be saying you only have 6 rows in the database with a value of 'van1'. I would have to say it is correct as the query is pretty straight forward. Have a close look at your data and see whats going on.
Is lower case an issue e.g. van vs Van?
There is no other data in the van column, trailing spaces, etc? You could test that with a LIKE against '%Van1%'