i have recently come across openfda.brand_name.exact. its getting the results where brand name is exact and also case sensitive for eg: the below url https://api.fda.gov/drug/label.json?search=openfda.brand_name.exact:"infants%20Tylenol"&limit=30 gives results but if i change the brand name to "infants tylenol", it wont be giving any results. is there any way where we can query for exact brand_names but with case in-sensitivity?
The brand_name.exact query term is case-sensitive.
You can search on brand_name instead of brand_name.exact to construct case-insensitive queries.
For example, these queries are case-insensitive:
1) https://api.fda.gov/drug/label.json?search=openfda.brand_name:%22infants%20tylenol%22
2) https://api.fda.gov/drug/label.json?search=openfda.brand_name:%22infants%20Tylenol%22
3) https://api.fda.gov/drug/label.json?search=openfda.brand_name:%22tylenol%20regular%20strength%22
4) https://api.fda.gov/drug/label.json?search=openfda.brand_name:%22TYLENOL%20Regular%20Strength%22
