I had similar pain for years, multiple steroid injections, failed back surgery and even had a spinal cord stimulator put in (permanently). For the best relief for acute pain was ice and special excercises prescribed by chiro and a physical therapist. "Adduction" and "abduction" of the knees.
Lie flat on your back on the floor, knees bent with feet on floor. Lift your hips and hold for count of 5 and go back down. Repeat a few times. In same position, put a pillow between your knees and squeeze your knees tightly together and hold to count of 10, relax and repeat about 2 to 5 times.
In same position, knees bent, feet on floor while on your back. Have someone hold your knees together while you try to pull your knees apart, to count of 5 to 10, repeat a few times. If you don't have someone to hold your knees, you can put a strap or belt around to keep you from pulling apart.
These movements open up the compression on the spine. You can do these a few times a day. For the abduction (pulling apart) you can do one leg at a time, by lying next to a bed or sofa and pressing your knee against the bed. The idea is to have "resistance" against the muscle.
For 3 years on total disability, walked with walker, had back and sciatic pain, foot drop, years of drs. and narcotics. I eventually got my life totally turned around, off all meds, off disability, no longer deal with any of that and no longer use the spinal cord stimulator, (still in my back for 8 years). The difference was by consuming completely balanced nutrition, with 25 years of researched and published studies with patented products that change lives every day.