Server: mysql.puroparty.com

Database: puroparty

Table: ads_ads

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): ad_id ad_status ad_user_id ad_category ad_date_begin ad_date_end ad_type ad_title ad_description ad_image1 ad_image2 ad_image3 ad_image4 ad_image5 ad_options ad_optional_1 ad_optional_2 ad_optional_3 ad_optional_4 ad_optional_5 ad_type_optional1 ad_type_optional2 ad_type_optional3 ad_type_optional4 ad_type_optional5 ad_type_optional6 ad_type_optional7 ad_type_optional8 ad_type_optional9 ad_type_optional10 ad_price ad_condition ad_views ad_address ad_city ad_state ad_postal ad_country ad_city_code ad_state_code ad_country_code ad_fee ad_anon_name ad_anon_email DISTINCT

Number of rows per page :   Display order: ad_id ad_status ad_user_id ad_category ad_date_begin ad_date_end ad_type ad_title ad_description ad_image1 ad_image2 ad_image3 ad_image4 ad_image5 ad_options ad_optional_1 ad_optional_2 ad_optional_3 ad_optional_4 ad_optional_5 ad_type_optional1 ad_type_optional2 ad_type_optional3 ad_type_optional4 ad_type_optional5 ad_type_optional6 ad_type_optional7 ad_type_optional8 ad_type_optional9 ad_type_optional10 ad_price ad_condition ad_views ad_address ad_city ad_state ad_postal ad_country ad_city_code ad_state_code ad_country_code ad_fee ad_anon_name ad_anon_email Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value ad_id int(10) = > >= < <= != LIKE NOT LIKE ad_status tinyint(1) = > >= < <= != LIKE NOT LIKE ad_user_id int(5) = > >= < <= != LIKE NOT LIKE ad_category int(5) = > >= < <= != LIKE NOT LIKE ad_date_begin varchar(10) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_date_end varchar(10) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_type tinyint(3) = > >= < <= != LIKE NOT LIKE ad_title varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_description text latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_image1 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_image2 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_image3 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_image4 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_image5 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_options int(10) = > >= < <= != LIKE NOT LIKE ad_optional_1 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_optional_2 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_optional_3 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_optional_4 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_optional_5 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_type_optional1 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_type_optional2 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_type_optional3 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_type_optional4 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_type_optional5 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_type_optional6 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_type_optional7 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_type_optional8 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_type_optional9 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_type_optional10 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_price varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_condition tinyint(4) = > >= < <= != LIKE NOT LIKE ad_views int(4) = > >= < <= != LIKE NOT LIKE ad_address varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_city varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_state varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_postal varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_country varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_city_code int(11) = > >= < <= != LIKE NOT LIKE ad_state_code int(4) = > >= < <= != LIKE NOT LIKE ad_country_code int(3) = > >= < <= != LIKE NOT LIKE ad_fee float(6,2) = > >= < <= != LIKE NOT LIKE ad_anon_name varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad_anon_email varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP