phpMyAdmin

Server:

mysql.puroparty.com

Database:

Table:

Structure

Browse

SQL

Search

Insert

Export

Empty

Drop

InnoDB free: 739328 kB

Field	Type	Function	Null	Value
segmentid	int(11)
segmentname	varchar(255)
createdate	int(11)
ownerid	int(11)
searchinfo	text			a:3:{s:5:"Lists";a:1:{i:0;s:1:"2";}s:5:"Rules";a:1:{i:0;a:3:{s:4:"type";s:5:"group";s:9:"connector";s:3:"and";s:5:"rules";a:1:{i:0;a:3:{s:4:"type";s:4:"rule";s:9:"connector";s:3:"and";s:5:"rules";a:3:{s:8:"ruleName";s:5:"email";s:12:"ruleOperator";s:7:"equalto";s:10:"ruleValues";a:1:{i:0;s:6:"swbell";}}}}}}s:6:"_cache";a:3:{s:12:"cacheVersion";i:20080526;s:11:"selectQuery";s:561:"SELECT DISTINCT subscribers.subscriberid AS subscriberid , subscribers.emailaddress AS emailaddress , subscribers.subscribedate AS subscribedate , subscribers.format AS format , subscribers.unsubscribed AS unsubscribed , subscribers.bounced AS bounced , subscribers.confirmed AS confirmed , subscribers.listid AS listid , lists.name AS listname FROM email_list_subscribers AS subscribers JOIN email_lists AS lists ON lists.listid = subscribers.listid AND lists.listid IN (2) WHERE subscribers.listid IN (2) AND ( ( subscribers.emailaddress LIKE '%swbell%' ) )";s:10:"countQuery";s:273:"SELECT COUNT(DISTINCT subscribers.subscriberid) AS count FROM email_list_subscribers AS subscribers JOIN email_lists AS lists ON lists.listid = subscribers.listid AND lists.listid IN (2) WHERE subscribers.listid IN (2) AND ( ( subscribers.emailaddress LIKE '%swbell%' ) )";}}

Save Or Insert as a new row	-- And --	Go back to previous page Or Insert another new row Or Go back to this page