Individual itineraries and the circulation of scientific and technical knowledge in East Asia (16th–20th centuries)

Project director : Catherine Jami (SPHERE); Jean-Pierre Dedieu (LARHRA)


How to perform query in SQL

You can access the database by clicking either "Actors" or "Places" (i.e. by accessing to the list of places where various events took place) at the top right corner of the homepage.

Whatever your choice, you can query the database by inserting your search text in the query field (upper right corner of the window) and then clicking on the binocular icon.

Syntax of queries – a few examples:

  • Querying Wang will yield as result all the persons, corporate entities and cultural objects that contain the word.
  • Querying “Mei Wending” will yield all actors whose name is exactly “Mei Wending”.
  • Querying Mei Wending will yield all actors whose name contains Mei and Wending.
  • Querying Mei Wen* will yield all actors whose name contains Mei and another word starting in Wen (including, but not exclusively, Mei Wending, Mei Wennai, Mei Wenmi, Mei Wencai).
  • Querying +Mei –Wending will yield all actors whose name contains “Mei” but not “Wending” in any of the fields.

Once you have found a relevant result to your query, you can access all the information concerning this specific actor or place by clicking on the corresponding identifier. 

Important: the search is performed in full-text mode in the whole database, and not in a specific field; if you want to restrict queries to specific fields, we invite you to use the Filemaker online version of the ICCM Database.

Last update on Monday 19 November 2012 (01:10) by  G. Foliot



© 2012 SHPERE - Projet Director: Catherine Jami
Site created by Gérald Foliot with webActors - Hosted by TGIR HUMA-NUM