Welcome to HCM.
Your pain appears to be due to disk prolapse in the vertebra, which is pressing on the nerve root
You Doctor has rightly prescribed the medicines for pain relief, but it will not treat the cause of pain.
You need to consult an orthopedic surgeon (Bone specialist) or Neuro-Surgeon ( Nerve and Brain Specialist) for diagnosing the cause by doing MRI
Scan, and treat according to the final Diagnosis.
Avoid carrying heavy weights, jumping, forward bending exercises etc. which compress the vertebral