Server:
mysql.puroparty.com
Database:
puroparty
Table:
wp_8_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