Server: mysql.puroparty.com

Database: puroparty

Table: email_list_subscribers

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 739328 kB

Select fields (at least one): subscriberid listid emailaddress domainname format confirmed confirmcode requestdate requestip confirmdate confirmip subscribedate bounced unsubscribed unsubscribeconfirmed formid DISTINCT

Number of rows per page :   Display order: subscriberid listid emailaddress domainname format confirmed confirmcode requestdate requestip confirmdate confirmip subscribedate bounced unsubscribed unsubscribeconfirmed formid Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value subscriberid int(11) = > >= < <= != LIKE NOT LIKE listid int(11) = > >= < <= != LIKE NOT LIKE emailaddress varchar(200) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL domainname varchar(100) 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 confirmed char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL confirmcode varchar(32) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL requestdate int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL requestip varchar(20) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL confirmdate int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL confirmip varchar(20) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL subscribedate int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL bounced int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL unsubscribed int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL unsubscribeconfirmed char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL formid int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL