Server:
mysql.puroparty.com
Database:
puroparty
Table:
extcal2_events
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Table holding events and their attributes
Select fields (at least one):
id
title
description
contact
url
email
picture
cat
day
month
year
approved
start_date
end_date
recur_type
recur_val
recur_end_type
recur_count
recur_until
DISTINCT
Number of rows per page :
Display order:
id
title
description
contact
url
email
picture
cat
day
month
year
approved
start_date
end_date
recur_type
recur_val
recur_end_type
recur_count
recur_until
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
id
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
title
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
description
text
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
contact
text
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
url
varchar(100)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
email
varchar(120)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
picture
varchar(100)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
cat
tinyint(2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
day
tinyint(2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
month
smallint(2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
year
smallint(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
approved
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
start_date
datetime
=
>
>=
<
<=
!=
LIKE
NOT LIKE
end_date
datetime
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
recur_type
varchar(16)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
recur_val
tinyint(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
recur_end_type
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
recur_count
tinyint(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
recur_until
date
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL