Server: mysql.puroparty.com

Database: puroparty

Table: email_newsletters

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 739328 kB

Select fields (at least one): newsletterid name format subject textbody htmlbody createdate active archive ownerid DISTINCT

Number of rows per page :   Display order: newsletterid name format subject textbody htmlbody createdate active archive ownerid Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value newsletterid int(11) = > >= < <= != LIKE NOT LIKE name varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL format char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL subject varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL textbody longtext utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL htmlbody longtext utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL createdate int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL active int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL archive int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL ownerid int(11) = > >= < <= != LIKE NOT LIKE