Open Data Stack Exchange is a question and answer site for developers and researchers interested in open data. It only takes a minute to sign up.
Sign up to join this community
I have recently come across openfda.brand_name.exact. It is getting the results where the brand name has to match exactly, i.e. also case sensitive. For example, the query
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" (small t), it won't return any results. Is there any way to query for exact brand_names, but with case in-sensitivity?
As you have observed, 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:
