Server: mysql.puroparty.com

Database: puroparty

Table: ads_ad_types

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): type_id type_title type_required type_use option1 def_option1 option2 def_option2 option3 def_option3 option4 def_option4 option5 def_option5 option6 def_option6 option7 def_option7 option8 def_option8 option9 def_option9 option10 def_option10 template DISTINCT

Number of rows per page :   Display order: type_id type_title type_required type_use option1 def_option1 option2 def_option2 option3 def_option3 option4 def_option4 option5 def_option5 option6 def_option6 option7 def_option7 option8 def_option8 option9 def_option9 option10 def_option10 template Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value type_id tinyint(3) = > >= < <= != LIKE NOT LIKE type_title varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP type_required int(6) = > >= < <= != LIKE NOT LIKE type_use int(6) = > >= < <= != LIKE NOT LIKE option1 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP def_option1 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP option2 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP def_option2 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP option3 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP def_option3 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP option4 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP def_option4 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP option5 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP def_option5 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP option6 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP def_option6 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP option7 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP def_option7 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP option8 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP def_option8 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP option9 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP def_option9 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP option10 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP def_option10 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP template mediumtext latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP