Meloxicam
"Got great relief after about 5 days. Don't know how I would have survived back spasms without it. 

To protect your gut from ulcers etc, you need to ask your doctor to also prescribe a drug called Nexium and take that in the morning and take the Mobic in the evening with food.

Shame it is not good to take this drug long term though."