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:

  1. openfda.brand_name:"infants tylenol"
  2. openfda.brand_name:"infants Tylenol"
  3. openfda.brand_name:"tylenol regular strength"
  4. openfda.brand_name:"TYLENOL Regular Strength"

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.