Server: mysql.puroparty.com

Database: puroparty

Table: email_stats_emailopens

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 738304 kB

Select fields (at least one): openid subscriberid statid opentime openip fromlink opentype DISTINCT

Number of rows per page :   Display order: openid subscriberid statid opentime openip fromlink opentype Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value openid int(11) = > >= < <= != LIKE NOT LIKE subscriberid int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL statid int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL opentime int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL openip varchar(20) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL fromlink char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL opentype char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL