I tweaked my back a few times many years ago and it always went when bending oddly (usually involved bending over and twisting to the left)
GP always said I just had a low tolerance to pain until one day it went and I couldn’t get up.
Went private that time and after an mri was diagnosed with a herniated disc at L5/S1 (lower right hand side).
Initially had localised imjections in my lower back which eased it for a few days but didn’t get rid of the pain.
A few weeks later I was back to have x-ray guided root blocker and something I can’t remember injections into the pockets of my spine on both sides. Eight in total all together and that got rid of all the pain in 24 hours.
The injection process itself felt very odd – like an elephant pressing on the spine. Not exactly painful just weird, and nearly as weird as watching the process on tv !
This was done 5 years ago now and whilst I can still bring on the localised pain if I put myself in daft positions, in the main I have been pain free through years of cycling and weight lifting / rowing / gym going.
If it does get tweaked beyond a minor annoyance, I lay down for a few hours then take diclofenac and a course or co codamol for 2 to 3 days before returning to normality. (Happened only twice in the last 4 years)
Sorry for the long winded post, but hope it helps a bit.