Pyrazole is a five-membered heterocycle bearing two adjacent nitrogen atoms. Both pharmaceutical agents and natural products with pyrazole as a nucleus have exhibited a broad spectrum of biological activities. In the last few decades, more than 40 pyrazole-containing drugs have been approved by the FDA for the treatment of a broad range of clinical conditions including celecoxib (anti-inflammatory), CDPPB (antipsychotic), difenamizole (analgesic), etc. Owing to the unique physicochemical properties of the pyrazole core, pyrazole-containing drugs may exert better pharmacokinetics and pharmacological effects compared with drugs containing similar heterocyclic rings. The purpose of this paper is to provide an overview of all the existing drugs bearing a pyrazole nucleus that have been approved or in clinical trials, involving their pharmacological activities and SAR studies.