How did people from the 1920s feel about prohibition?

At the beginning, many people were very optimistic but as its failures became increasingly evident more and more people came to oppose Prohibition. By the time of its repeal, 74% of voters opposed it.