CoCoMac logo

CoCoMac Direct SQL Query

Send a parameterized SQL query to the CoCoMac database and retrieve the results in html, plain text or json format.

The tables and fields of the database are listed here.
For the stability of our server, the query must meet these requirements:

To include string values in your query, give the value a name, and enter it as $name in the query.
Example:
  SELECT * FROM Literature WHERE TextID=$lit
On submit, you will be asked to provide values for your named parameters.

Web-safe sql query: