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