Banning prostitution from Auckland's troublespots will not be a job for the Government.
Instead, Auckland Council has been told it already has the power to pass a bylaw to address the problem.
There had been interest in the law change because other cities, in particular Christchurch, were keen to have similar powers to ban prostitution near schools, family homes or sports facilities.
But yesterday a bill that was introduced by former Labour MP George Hawkins in 2010 was defeated on its second reading by 109-11.
New Zealand First was the only party to vote in favour.