Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_users
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 733184 kB
Select fields (at least one):
userid
username
password
admintype
listadmintype
templateadmintype
segmentadmintype
status
fullname
emailaddress
settings
editownsettings
usertimezone
textfooter
htmlfooter
maxlists
perhour
permonth
unlimitedmaxemails
maxemails
infotips
smtpserver
smtpusername
smtppassword
smtpport
createdate
lastloggedin
forgotpasscode
usewysiwyg
xmlapi
xmltoken
gettingstarted
DISTINCT
Number of rows per page :
Display order:
userid
username
password
admintype
listadmintype
templateadmintype
segmentadmintype
status
fullname
emailaddress
settings
editownsettings
usertimezone
textfooter
htmlfooter
maxlists
perhour
permonth
unlimitedmaxemails
maxemails
infotips
smtpserver
smtpusername
smtppassword
smtpport
createdate
lastloggedin
forgotpasscode
usewysiwyg
xmlapi
xmltoken
gettingstarted
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
userid
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
username
varchar(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
password
varchar(32)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
admintype
char(1)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
listadmintype
char(1)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
templateadmintype
char(1)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
segmentadmintype
char(1)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
status
char(1)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
fullname
varchar(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
emailaddress
varchar(100)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
settings
text
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
editownsettings
char(1)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
usertimezone
varchar(10)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
textfooter
mediumtext
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
htmlfooter
mediumtext
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
maxlists
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
perhour
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
permonth
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
unlimitedmaxemails
char(1)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
maxemails
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
infotips
char(1)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
smtpserver
varchar(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
smtpusername
varchar(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
smtppassword
varchar(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
smtpport
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
createdate
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
lastloggedin
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
forgotpasscode
varchar(32)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
usewysiwyg
char(1)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
xmlapi
char(1)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
xmltoken
varchar(40)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
gettingstarted
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE