Entering parameter
values/ranges in the upper part of the Query Page, checking the appropriate
Use boxes. All used values/ranges are combined with logical
AND. New: Clicking in an input box auto-selects
the appropriate Use check-box
Make sure the Query box at the bottom is unchecked.
Entering the WHERE part of a SQL query in the lower part of the Query
Page.
Make sure the Query box
at the bottom is checked.
In any case, check Show boxes of all parameters to be returned by
the query.
Parameter ranges
A range of a numerical parameter may be specified by entering minimum and
maximum value. If only one value is given, it serves as lower or
upper limit. See below for special rules for RA/Decl.
Field, StarID and StarCat parameters may only be specified as single
values. For more complicated criteria a SQL query may be used, see below.
Coordinates ranges
For RA/Decl coordinates the range may be specified in three
ways:
Normal min/max range values
A circle around the point
specified by left values. The circle radius in arc seconds
should be given in one (and only one) right value by
prefixing it with letter 'r':
RA
Dec
A rectangle centered on the point
specified by left values. Both right values should be given
prefixed with 'r' with the meaning of the rectangle half width/height in
arc seconds:
RA
Dec
SQL queries
The WHERE part of a SQL query is constructed as a logical expression, using
parameter names (case-insensitive), parentheses and relational/logical
operators: = != < >= &&/and ||/oretc.
Notes:
The equality operator is a single '=', not '==' as in C
Object Declination parameter name is Decl, not
Dec
String constants must be enclosed in single apostrophes:
'text'
For string parameters (Field, StarCat, ID_XXXXX) one can use
like
operator allowing to use wildcards:'%' for any sequence
of characters, '_' for any single character.
OGLE-III field names consist of the the main part and a numerical
suffix (1-8) for each of the mosaic camera chip, e.g.LMC161.7
Pulsation mode is internally stored in simplified form which must be used
in raw SQL queries. It consists of 'F' for fundamental and 'N' for
N-th overtone. So 'F1' stands for 'F/1O', '12' for '1O/2O' etc.
The MySQL server does not recognize the hexagesimal format for RA/Decl. To use
it in the WHERE part of the query, put the HH:MM:SS.S string in single
apostrophes as argument to
h2d() function (see Examples below).
Examples
Decl>-70 and Decl<-69.995 and P_1>0.8
RA>h2d('5:01:00') and RA<h2d('5:05:00') and Mode='F1'
field='LMC161.6' and A_1>0.3
ID_MACHO like '%'
- to get all stars with MACHO cross-identification