Server:
mysql.puroparty.com
Database:
puroparty
Table:
extcal_categories
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Table for event categories
Select fields (at least one):
cat_id
cat_parent
cat_name
description
color
bgcolor
options
enabled
DISTINCT
Number of rows per page :
Display order:
cat_id
cat_parent
cat_name
description
color
bgcolor
options
enabled
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
cat_id
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
cat_parent
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
cat_name
varchar(150)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
description
text
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
color
varchar(10)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
bgcolor
varchar(10)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
options
tinyint(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
enabled
tinyint(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL