Hi there
Does the pain travel down your legs, or does it stay in the lower back area .....
What does your physsician mean by a 'knot' is this a muscle that has knotted ?
Sharp and shooting pains are usually caused by trapped nerves or pulled muscles.
However, if the pain comes and goes, it's more likely to be trapped nerves.
I do sympatise with you, as back pain of any kind will sometimes immobilse you
for a while causing extreme pain.
The area becomes inflammed (internal swelling), so taking an anti-imflammatory pain killer will help,
along with 'ice pack' to reduce the intrenal swelling.
If this doesn't get better, then please go back to your Doctor and insist on further tests.
Hope this helps ....
Best wishes
Ginger