Server: mysql.puroparty.com

Database: puroparty

Table: ads_categories

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): category_id category_order category_parent category_title category_desc category_img category_ad_types category_ad_prices category_optional_1 category_optional_1_def category_optional_2 category_optional_2_def category_optional_3 category_optional_3_def category_optional_4 category_optional_4_def category_optional_5 category_optional_5_def category_subs category_listings banner_top banner_bottom category_related DISTINCT

Number of rows per page :   Display order: category_id category_order category_parent category_title category_desc category_img category_ad_types category_ad_prices category_optional_1 category_optional_1_def category_optional_2 category_optional_2_def category_optional_3 category_optional_3_def category_optional_4 category_optional_4_def category_optional_5 category_optional_5_def category_subs category_listings banner_top banner_bottom category_related Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value category_id int(5) = > >= < <= != LIKE NOT LIKE category_order int(3) = > >= < <= != LIKE NOT LIKE category_parent int(5) = > >= < <= != LIKE NOT LIKE category_title varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP category_desc text latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP category_img varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP category_ad_types varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP category_ad_prices varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP category_optional_1 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP category_optional_1_def varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP category_optional_2 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP category_optional_2_def varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP category_optional_3 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP category_optional_3_def varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP category_optional_4 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP category_optional_4_def varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP category_optional_5 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP category_optional_5_def varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP category_subs int(5) = > >= < <= != LIKE NOT LIKE category_listings int(5) = > >= < <= != LIKE NOT LIKE banner_top varchar(5) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP banner_bottom varchar(5) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP category_related varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP