finding text in a string
The IN operator expects a list of items, not a single string.
You need to structure your query as follows:

Select * from table where mid(postcode,1,2) IN ('CV','DE','LE','MK','NN');