Table Description

Usage

• To execute any search, press enter key after entering text in column text entry area.
• Shift+click on sort arrows (▼ or ▲) to sort on multiple columns.
• A entry of ⎵ means value is a single blank space.
• To show only certain columns, enter, e.g., _cols=a,b,c and reload page to apply changes.

Search

• A search string abc on a column results in an SQL LIKE = '%abc%' query. See SQL LIKE for more information on the SQL LIKE operator.
• However, if search string starts and/or ends with %, the percentage wildcards are not added automatically.
• Escape % and _ using \. Escape \ with \\.
• For an exact match search for abc, use single quotes: 'abc'.
• Escape single quotes by repeating, e.g., '''single quoted string'''.
• All table entries are strings.