Server: mysql.puroparty.com

Database: puroparty

Table: jos_bannerclient

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): cid name contact email extrainfo checked_out checked_out_time editor DISTINCT

Number of rows per page :   Display order: cid name contact email extrainfo checked_out checked_out_time editor Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value cid int(11) = > >= < <= != LIKE NOT LIKE name varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP contact varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP email varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP extrainfo text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP checked_out tinyint(1) = > >= < <= != LIKE NOT LIKE checked_out_time time = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL editor varchar(50) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL