Skip to Main Content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

Scoping Reviews: Run your search on other databases

Library guide for the development of scoping reviews and their associated systematic searches, and required reporting.

Run your search on other databases

Run your search on other databases

After you have run your search on MEDLINE, you need to run it on your other databases. Your new search should be the same as your MEDLINE search, only changing as much as necessary to get it to work in the new database.

This page will show you how to remap your master MEDLINE search to other Ovid databases (Embase, Emcare, and PsycINFO), PubMed, The Cochrane Library, Scopus, and Web of Science.

Please note: database interfaces change frequently, and some of the resources on this page no longer match the current interfaces. The Library is currently reviewing all resources on this page.
NEW December 2021/January 2022: the following PDF guides show how to translate your search to a range of databases. Correct at the time of production but subject to interface changes!

Search syntax

Different databases use different search syntax, operators, and default search fields. When you are remapping your master search to your chosen databases, it is important to consider whether you will need to adapt any aspects of your search strategy such as phrase searches, truncation, wildcards, and adjacency.

The PDF below shows how to translate these elements across a number of key databases:

Translating a search in Ovid - method 1

The steps below represent our recommended method of translating a search to another database on the Ovid platform, to save time and reduce errors.

  • Create draft / master search in MEDLINE (Ovid)
  • Share strategy with yourself via Email All Search History option
  • Copy keyword lines from plain text section of Ovid email and save in plain text editor such as Notepad (PC) or TextEdit (Mac)
  • This will be your master keyword file - these are the keywords that you will use across every database (including those without subject headings, such as Scopus)
  • Copy MEDLINE subject headings into a MeSH column
  • Create columns for all other relevant thesauri e.g. Emtree (Embase, Emcare) and APA (PsycInfo)
  • You may find a notes column for each thesaurus helpful
  • Search for subject headings for each concept as you did for MEDLINE
  • You may find that the heading is the same, slightly different, a synonym, or not available as a subject heading in this thesaurus
  • Beware that exploding subject headings may find a different set of narrower terms in the new database
  • Add equivalent and new subject headings to the spreadsheet
  • Revisit your previous databases and check if newly discovered subject headings have equivalents
  • Update keyword lines in master keyword file with newly discovered terms (e.g from Emtree scope notes, or new subject headings)
  • Create new plain text file with subject headings for that database, master keyword lines, and line combinations (e.g. 3 AND 7)

Translating a search in Ovid - method 2

Select the headings below to learn how to remap your MEDLINE search to other Ovid databases. The process is the same whether you are remapping to Embase, Emcare, or PsycINFO.

Select the headings below to learn how to remap your search in Ovid.

  • Log in to MEDLINE and run your search.
  • Then select Change under the Search Tools box.

Ovid search interface

  • A new window will appear, listing the range of Ovid databases.
  • Select one of the databases to search (eg Embase) and then select Run Search.
  • Ovid will now run your search on this new database, ready for you to check and correct.
  • Your subject heading lines can be identified by the presence of a forward slash / after the term, see below.

    Screenshot of Medline search history with back pain subject line, showing back slash after the term to denote a subject heading
     
  • You will need to check any MeSH to ensure that they have mapped across correctly. To do this:
    • Look up each term without the forward slash (e.g. enter back pain not back pain/).
    • • You may find that the heading is the same, slightly different, a synonym, or not available as a subject heading in this thesaurus.
    • Check the scope note (i icon on right) to establish that headings cover the same ideas as the original MeSH.

      Ovid search interface
       
  • Select the subject heading hyperlink to view the subject hierarchy - you may identify additional related or nested terms.

Note: Emcare and Embase share the same subject headings, so if you have run your search on Embase, you can rerun it on Emcare without any changes.

  • Keyword lines will not have a forward slash/ and will end in a field code such as .mp, which is the default code in Ovid.

Screenshot of Medline Search history showing keyword line with .mp shown after keyword terms

  • ​When remapping searches to different Ovid databases, you do not generally need to change your keyword lines.
  • You may, however, choose to change your field codes. E.g. to search across title, abstract and author-supplied fields in MEDLINE you would use .tw,kf. To search those same fields in Embase, you would need to change this to .ti,ab,kw.
  • When you have identified the correct subject headings for this database, you need to edit your search by selecting More > Edit.

    Ovid search history
     
  • Replace the term with the new subject heading, being sure to add the forward slash after the term (eg Backache/)
  • Run the search 
  • Save your search as a new copy. Include the database name in the title (eg Search: Embase version)
  • If you discover additional relevant subject headings, you can add these to your search. Just be sure to:
    • Revisit your previous databases and check if the term (or a similar subject heading) appears.
    • If so, add it to those searches too, and correct your combination lines.
    • Regardless, update the keyword line to include the new term for all databases.
  • If the subject headings are too broad or are not relevant, remove that subject heading line from your search. Be sure to correct your combination lines.
  • Remember the aim is to cover the same search scope as your master MEDLINE search.
Note: Embase and Emcare both use the same subject headings (the 'Emtree'), so mapping between these two databases is usually not necessary. However, Emcare subject headings are updated annually (Jan), while Embase subjects headings are updated three times a year. This means the two versions of the Emtree might be slightly inconsistent towards the end of the calendar year. To avoid this, double-check any Emcare subject heading lines that yield 0 results. 

Guidelines and standards

'If a tool was used to automatically translate search strings for one database to another, specify the tool used.' PRISMA 2020 Explanation and Elaboration, p. 7


Other standards

Translating your search - videos

The following videos are complementary resources to the corresponding 'Translating your search' PDF documents, found on this page. They are current at March 2022.

Translating your search from MEDLINE to Scopus (5:31):

Translating your search from MEDLINE to Web of Science (5:04):

Remap to the Cochrane Library

The Cochrane Library has its own interface so you will need to re-enter your entire search. You will need to search for your subject heading lines and your keywords lines, just like searching in Ovid.

Select the headings below to learn how to remap your search in Cochrane.

In the Cochrane Library, you need to build your search with Search manager:

  • Select the Search manager tab, then go to Advanced Search > Search manager
  • Select the MeSH button and add in your subject headings from MEDLINE. These will be the same terms as both interfaces use MeSH.

    Screenshot of cochrane search manager interface
     
  • If you used the explode option on any subject headings in Ovid, you will need to do the same in Cochrane.

Screenshot of Cochrane search thesaurus

After adding each subject heading line, you need to add the corresponding keyword line.

  • Go back to the Search manager tab.
  • Start adding in your keyword string in line #2.
  • Add double quotes around all phrases that do not contain a truncation or wildcard symbol (eg "back pain")
  • For those phrases that do contain a truncation or wildcard symbol, add NEXT between the words and brackets around it instead (eg cardio* NEXT disease).

Cochrane search manager combining subject heading lines and keyword lines

  • If a truncated phrase contains an AND/OR/NOT, put this in double quotes (eg mother? NEXT "and" NEXT bab*)
  • When combining your subject heading lines and keyword lines, include the # before the numbers for your combination lines (eg #1 or #2)

Note: If you used proximity/adjacency symbols (ie in MEDLINE adj3 etc), you'll need to change these to near/3 .

Watch the videos below to learn more about using the search manager in the Cochrane Library. 

Video Length: 1:05

Navigate to video: Adding MeSH to your Cochrane Library search

Video Length: 1:03

Navigate to video: Using the search manager in your Cochrane Library search

Navigate to report broken links and provide feedback page