Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_list_subscribers
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 730112 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