I am interested in finding a syntax for the LIKE search condition.

The query syntax example is https://api.fda.gov/drug/ndc.json?search=brand_name:aspirin

I have to enter the whole word (aspirin) for getting result. Is there any way to get result with the part of the word (for example "asp"), using symbols like % or %s for LIKE search?

Getting no result with this query https://api.fda.gov/drug/ndc.json?search=brand_name:aspiri%

1 Answer 1


I'm Jack with the openFDA team. At the moment there is no LIKE search condition enabled for openFDA. We will discuss it internally and consider the implementation of this feature. For more details on the available search features, please check the documentation.

  • Hi Jack, thanks for your answers today. Please consider setting an alert on openfda, or coming back more often. Users from your site are directed to this site, which is fine as long as someone is here to answer.
    – philshem
    Mar 30, 2020 at 16:32
  • Also, still many to answer! opendata.stackexchange.com/questions/tagged/openfda
    – philshem
    Mar 30, 2020 at 16:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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