Why are the results of two search statements inconsistent?

Question

https://api.fda.gov/drug/event.json?search=(receivedate:[20040108+TO+20210401])+AND+patient.drug.medicinalproduct:%22IBUPROFEN%22&count=patient.reaction.reactionmeddrapt.exact

Using the above search request, I get values as (full response)

"term": "PAIN", "count": 9080

.

https://api.fda.gov/drug/event.json?search=(receivedate:[20040108+TO+20210401])+AND+patient.drug.medicinalproduct.exact:%22IBUPROFEN%22+AND+patient.reaction.reactionmeddrapt.exact:%22PAIN%22

Using the above search request, I get (full response)

"total": 2914

How does the above two search requests differentiate so that the result are different?

Answer 1

Your former query is using patient.drug.medicinalproduct while the latter is using patient.drug.medicinalproduct.exact. The exact part is what makes the difference.