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