Server:
mysql.puroparty.com
Database:
puroparty
Table:
phorum_forums
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Select fields (at least one):
forum_id
name
active
description
template
folder_flag
parent_id
list_length_flat
list_length_threaded
moderation
threaded_list
threaded_read
float_to_top
check_duplicate
allow_attachment_types
max_attachment_size
max_totalattachment_size
max_attachments
pub_perms
reg_perms
display_ip_address
allow_email_notify
language
email_moderators
message_count
sticky_count
thread_count
last_post_time
display_order
read_length
vroot
edit_post
template_settings
count_views
display_fixed
reverse_threading
inherit_id
DISTINCT
Number of rows per page :
Display order:
forum_id
name
active
description
template
folder_flag
parent_id
list_length_flat
list_length_threaded
moderation
threaded_list
threaded_read
float_to_top
check_duplicate
allow_attachment_types
max_attachment_size
max_totalattachment_size
max_attachments
pub_perms
reg_perms
display_ip_address
allow_email_notify
language
email_moderators
message_count
sticky_count
thread_count
last_post_time
display_order
read_length
vroot
edit_post
template_settings
count_views
display_fixed
reverse_threading
inherit_id
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
forum_id
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
name
varchar(50)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
active
smallint(6)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
description
text
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
template
varchar(50)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
folder_flag
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
parent_id
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
list_length_flat
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
list_length_threaded
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
moderation
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
threaded_list
tinyint(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
threaded_read
tinyint(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
float_to_top
tinyint(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
check_duplicate
tinyint(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
allow_attachment_types
varchar(100)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
max_attachment_size
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
max_totalattachment_size
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
max_attachments
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
pub_perms
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
reg_perms
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
display_ip_address
smallint(5)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
allow_email_notify
smallint(5)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
language
varchar(100)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
email_moderators
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
message_count
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
sticky_count
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
thread_count
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
last_post_time
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
display_order
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
read_length
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
vroot
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
edit_post
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
template_settings
text
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
count_views
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
display_fixed
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
reverse_threading
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
inherit_id
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL