Search a school
This form allows to search the database for a school.
If data are incorrect, please send an updating.
But first note the school key. If a school is missing, you may add it.
The 'contains' operator ignores case, i.e. upper and lower case characters
are considered equal, except for non-English characters. Other operators are
case-sensitive.
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.
Operators
- Logical : AND, OR
- Comparison : =, <> (not equal), <, <=, >, >=, LIKE, contains
- Special characters for 'LIKE' and 'contains' value (right field) :
- '-' matches any single character
- '%' matches 0 or more characters of any value
- '\' escapes the special characters ( e.g. '\%' matches %)
Always use wildcards with LIKE (otherwise it's an 'equal to').
E.g. : all e-mail addresses from the German School net, i.e. addresses ending on 'schule.de' :
Select .... where school email LIKE '%schule.de', or : ... contains 'schule.de'
or a school with the word "Business" somewhere in the name :
...where name of school contains 'business', or ... LIKE '%Business%'
School types
- PS: primary school (and Kindergarten)
- MS: middle school (ages 10-14 in certain countries)
- GS: general secondary
- TS: technical secondary
- VS: vocational secondary
- H : higher education (ages > 17)
- U : university
- A : public authority
- TT: teacher training institution
- CO: commercial company
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