mysql.dds.nl
crstaalm
pro vita humana
"artikelen PVH"
Browse
Structure
SQL
Search
Insert
Export
Operations
Empty
Drop
Select fields (at least one):
jaar
jaargang
auteur
titel
tekst
noten
volledig artikel
DISTINCT
Number of rows per page :
Display order:
jaar
jaargang
auteur
titel
tekst
noten
volledig artikel
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Operator
Value
jaar
year(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
jaargang
year(2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
auteur
varchar(255)
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
titel
varchar(255)
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
tekst
longtext
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
noten
longtext
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
volledig artikel
longtext
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL