Server:
mysql.puroparty.com
Database:
puroparty
Table:
wp_users
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Select fields (at least one):
ID
user_login
user_pass
user_nicename
user_email
user_url
user_registered
user_activation_key
user_status
display_name
spam
deleted
DISTINCT
Number of rows per page :
Display order:
ID
user_login
user_pass
user_nicename
user_email
user_url
user_registered
user_activation_key
user_status
display_name
spam
deleted
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
user_login
varchar(60)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
user_pass
varchar(64)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
user_nicename
varchar(50)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
user_email
varchar(100)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
user_url
varchar(100)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
user_registered
datetime
=
>
>=
<
<=
!=
LIKE
NOT LIKE
user_activation_key
varchar(60)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
user_status
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
display_name
varchar(250)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
spam
tinyint(2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
deleted
tinyint(2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE