Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_jobs
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 737280 kB
Select fields (at least one):
jobid
jobtype
jobstatus
jobtime
jobdetails
fkid
lastupdatetime
fktype
queueid
ownerid
approved
authorisedtosend
resendcount
DISTINCT
Number of rows per page :
Display order:
jobid
jobtype
jobstatus
jobtime
jobdetails
fkid
lastupdatetime
fktype
queueid
ownerid
approved
authorisedtosend
resendcount
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
jobid
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
jobtype
varchar(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
jobstatus
char(1)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
jobtime
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
jobdetails
text
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
fkid
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
lastupdatetime
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
fktype
varchar(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
queueid
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
ownerid
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
approved
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
authorisedtosend
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
resendcount
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL