To look for case studies in any of the databases linked to from this page, use keywords: "case stud*" AND addiction, "mental health," HIV/AIDS, etc.
The asterisk will retrieve both the singular and the plural of a word and the quotes will search for the full phrase.