Server:
mysql.puroparty.com
Database:
puroparty
Table:
phorum_users
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Select fields (at least one):
user_id
username
password
cookie_sessid_lt
sessid_st
sessid_st_timeout
password_temp
email
email_temp
hide_email
active
user_data
signature
threaded_list
posts
admin
threaded_read
date_added
date_last_active
last_active_forum
hide_activity
show_signature
email_notify
pm_email_notify
tz_offset
is_dst
user_language
user_template
moderator_data
moderation_email
DISTINCT
Number of rows per page :
Display order:
user_id
username
password
cookie_sessid_lt
sessid_st
sessid_st_timeout
password_temp
email
email_temp
hide_email
active
user_data
signature
threaded_list
posts
admin
threaded_read
date_added
date_last_active
last_active_forum
hide_activity
show_signature
email_notify
pm_email_notify
tz_offset
is_dst
user_language
user_template
moderator_data
moderation_email
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
user_id
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
username
varchar(50)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
password
varchar(50)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
cookie_sessid_lt
varchar(50)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
sessid_st
varchar(50)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
sessid_st_timeout
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
password_temp
varchar(50)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
email
varchar(100)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
email_temp
varchar(110)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
hide_email
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
active
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
user_data
text
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
signature
text
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
threaded_list
tinyint(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
posts
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
admin
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
threaded_read
tinyint(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
date_added
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
date_last_active
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
last_active_forum
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
hide_activity
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
show_signature
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
email_notify
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
pm_email_notify
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
tz_offset
tinyint(2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
is_dst
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
user_language
varchar(100)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
user_template
varchar(100)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
moderator_data
text
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
moderation_email
tinyint(2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE