Search a past project
The text searches ignore case, i.e. upper and lower case characters are considered
equal, except for non-English characters.
Always use a % character as wildcard with the LIKE operator, otherwise
it is an 'equal to' instead of 'like'.
For more explanations on operators, see below.
Only 1 word or part of a word may be entered as value! If you want
to use more than 1, use both input fields and combine by OR or AND.
Ages are specified by the corresponding grade (in hexadecimal):
| Age |
<6 | 6 |
7 | 8 | 9 | 10 | 11 | 12 |
13 | 14 | 15 | 16 | 17 | 18 |
19 | >19 |
| Grade |
K | 1 | 2 | 3 | 4 |
5 | 6 | 7 | 8 |
9 | A | B | C | D |
E | F |
Give range of grades as consecutive hexadecimal digits e.g. the range 8-12
(age 13-17) as 89ABC
Operators
- Logical : AND, OR
- Comparison : =, <> (not equal), <, <=, >, >=, LIKE, contains
- Special characters for 'LIKE' and 'contains' value (right field) :
Always use wildcards with LIKE (otherwise it's an 'equal to').
- '_' matches any single character
- '%' matches 0 or more characters of any value
- '\' escapes the special characters ( e.g. '\%' matches %)
E.g. : all e-mail addresses from the German School net, i.e. addresses ending on 'schule.de' :
Select .... where email LIKE '%schule.de%', or: ... email contains 'schule.de'
Search for a [person]
[school] [project or request] [past
project]
Add a [person] [school] [project]
[request for partners]
Update the data of a [person] [school]
[project] [request]
Project titles, with start of description -
Project titles only
Past Projects titles
Database home page
ESP projects database
Administrator:
Hubert Christiaen, Belgium