Server: mysql.puroparty.com

Database: puroparty

Table: email_lists

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 739328 kB

Select fields (at least one): listid name ownername owneremail bounceemail replytoemail bounceserver bounceusername bouncepassword extramailsettings companyname companyaddress companyphone format notifyowner imapaccount createdate subscribecount unsubscribecount bouncecount processbounce agreedelete visiblefields ownerid DISTINCT

Number of rows per page :   Display order: listid name ownername owneremail bounceemail replytoemail bounceserver bounceusername bouncepassword extramailsettings companyname companyaddress companyphone format notifyowner imapaccount createdate subscribecount unsubscribecount bouncecount processbounce agreedelete visiblefields ownerid Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value listid int(11) = > >= < <= != LIKE NOT LIKE name varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL ownername varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL owneremail varchar(100) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL bounceemail varchar(100) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL replytoemail varchar(100) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL bounceserver varchar(100) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL bounceusername varchar(100) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL bouncepassword varchar(100) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL extramailsettings varchar(100) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL companyname varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL companyaddress varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL companyphone varchar(20) 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 notifyowner char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL imapaccount char(1) 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 subscribecount int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL unsubscribecount int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL bouncecount int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL processbounce char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL agreedelete char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL visiblefields text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ownerid int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL