So you've found, scrounged, thrifted or been gifted a great new (to you) lamp, but there's a problem that spray paint can't solve. It has a broken bulb stuck in the fixture!
The best solution is to get a potato that's just a bit larger than the remaining bulb parts (any type will do--it's best not to eat it afterwards anyways). Cut off one end so that you have a flat, skinless surface to work with.
Unplug the lamp, and then, holding with the cut end of the potato towards the base of the bulb, slowly but firmly impale the potato on the broken bulb, like this:
Once the potato is firmly in place, you can turn it (lefty loosey, of course) and the base of the bulb will turn with it, unscrewing the bulb from the lamp.
Put in a new bulb (of course you'll be using a super efficient compact fluorescent, right?) And voila, you have a lovely new lamp!
This beautiful lamp came to us courtesy of James' Aunt Sue!