Server: mysql.puroparty.com

Database: puroparty

Table: extcal_2groups

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