Server:
mysql.puroparty.com
Database:
puroparty
Table:
extcal_1groups
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Table holding user groups
Select fields (at least one):
group_id
group_name
description
has_admin_access
can_manage_accounts
can_change_settings
can_manage_cats
can_create_events
can_edit_events
can_submit_events
upl_need_approval
locked
DISTINCT
Number of rows per page :
Display order:
group_id
group_name
description
has_admin_access
can_manage_accounts
can_change_settings
can_manage_cats
can_create_events
can_edit_events
can_submit_events
upl_need_approval
locked
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
group_id
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
group_name
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
description
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
has_admin_access
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
can_manage_accounts
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
can_change_settings
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
can_manage_cats
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
can_create_events
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
can_edit_events
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
can_submit_events
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
upl_need_approval
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
locked
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE