Unfortunately, no, alcohol prohibition did not work in the US. Like much of half-thought-through legislation the ramifications were probably worse than the original alcohol problems. It was understandable that legislators wanted to curb the drunken and uncontrolled behaviour on the streets.
However, prohibition only affected the sale and movement of alcohol, not the consumption. People could legally produce and consume alcohol - to whatever extent - in their own homes. Breweries selling alcohol went out of business and those who drank to excess continued to do so. Economically the effect on the US economy was harmful. Eventually, around 1920, legislation was changed accordingly.
The prohibition took place in the 1920s and lasted up to 1933. This was created in order to improve the hygiene of people in the USA. It only prohibited the selling, manufacturing, and transportation of alcohol. Those who already have their own collection of alcohol can enjoy the beverages whenever they can. It only proceeded to divide some of the states because some states resisted the effect.
There were thousands of people who lost their jobs because they worked in breweries. The restaurants have noticed a decline in their sales. In general, the prohibition proved to be bad for the economy. This may have lasted for a more than a decade but it was problematic from the time it started.