Once in a while:
For the occasional achy hip or shoulder, either acetaminophen or an NSAID (which may help more if there's inflammation) should do the trick, says Fishman.

You need something stronger:
Treatments include prescription-level NSAIDS, muscle relaxants, short-acting opioids, and corticosteroid shots. Chronic pain patients may also be prescribed the new fibromyalgia drug Lyrica, as well as certain antidepressants.