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