Server: mysql.puroparty.com

Database: puroparty

Table: jos_banner

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): bid cid type name alias imptotal impmade clicks imageurl clickurl date showBanner checked_out checked_out_time editor custombannercode catid description sticky ordering publish_up publish_down tags params DISTINCT

Number of rows per page :   Display order: bid cid type name alias imptotal impmade clicks imageurl clickurl date showBanner checked_out checked_out_time editor custombannercode catid description sticky ordering publish_up publish_down tags params Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value bid int(11) = > >= < <= != LIKE NOT LIKE cid int(11) = > >= < <= != LIKE NOT LIKE type varchar(30) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP name varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP alias varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP imptotal int(11) = > >= < <= != LIKE NOT LIKE impmade int(11) = > >= < <= != LIKE NOT LIKE clicks int(11) = > >= < <= != LIKE NOT LIKE imageurl varchar(100) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP clickurl varchar(200) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP date datetime = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL showBanner tinyint(1) = > >= < <= != LIKE NOT LIKE checked_out tinyint(1) = > >= < <= != LIKE NOT LIKE checked_out_time datetime = > >= < <= != LIKE NOT LIKE editor varchar(50) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL custombannercode text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL catid int(10) = > >= < <= != LIKE NOT LIKE description text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP sticky tinyint(1) = > >= < <= != LIKE NOT LIKE ordering int(11) = > >= < <= != LIKE NOT LIKE publish_up datetime = > >= < <= != LIKE NOT LIKE publish_down datetime = > >= < <= != LIKE NOT LIKE tags text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP params text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP