Wouldn't this select do the same thing, only faster:
select * from view1 where year = "2001" and acc_field like "5%"

and if exact is set off, like "5%" could be replaced with = "5".
If you need distinct before the *, that would mean that you must have entire rows duplicated, which would signal a db design flaw (my opinion).