Server: mysql.puroparty.com

Database: puroparty

Table: wp_9_posts

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): ID post_author post_date post_date_gmt post_content post_title post_category post_excerpt post_status comment_status ping_status post_password post_name to_ping pinged post_modified post_modified_gmt post_content_filtered post_parent guid menu_order post_type post_mime_type comment_count DISTINCT

Number of rows per page :   Display order: ID post_author post_date post_date_gmt post_content post_title post_category post_excerpt post_status comment_status ping_status post_password post_name to_ping pinged post_modified post_modified_gmt post_content_filtered post_parent guid menu_order post_type post_mime_type comment_count Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value ID bigint(20) = > >= < <= != LIKE NOT LIKE post_author bigint(20) = > >= < <= != LIKE NOT LIKE post_date datetime = > >= < <= != LIKE NOT LIKE post_date_gmt datetime = > >= < <= != LIKE NOT LIKE post_content longtext utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP post_title text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP post_category int(4) = > >= < <= != LIKE NOT LIKE post_excerpt text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP post_status varchar(20) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP comment_status varchar(20) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ping_status varchar(20) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP post_password varchar(20) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP post_name varchar(200) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP to_ping text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP pinged text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP post_modified datetime = > >= < <= != LIKE NOT LIKE post_modified_gmt datetime = > >= < <= != LIKE NOT LIKE post_content_filtered text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP post_parent bigint(20) = > >= < <= != LIKE NOT LIKE guid varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP menu_order int(11) = > >= < <= != LIKE NOT LIKE post_type varchar(20) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP post_mime_type varchar(100) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP comment_count bigint(20) = > >= < <= != LIKE NOT LIKE