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