Page History

...

There are a number of SQL queries that can be used to retrieve data from the database. Only (read-only) statements are supported. Statements must be formatted as:

Wiki MarkupSELECT [DISTINCT] <select_expr> FROM TABLE_NAME [WHERE <where_condition>] \ [ORDER BY COLUMN_NAME [ASC |DESC]\]

<select_expr>: (* | <COLUMN_NAME , COLUMN_NAME, ...)

<where_condition>: COLUMN_NAME <operator> AND <where_condition> \ OR <where_condition> \ LIKE <where_condition>

<operator>: (= | <> | < | > <value>) | BETWEEN <value> AND <value>

...