Server:
mysql.puroparty.com
Database:
puroparty
Table:
phorum_messages
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Select fields (at least one):
message_id
forum_id
thread
parent_id
author
subject
body
email
ip
status
msgid
modifystamp
user_id
thread_count
moderator_post
sort
datestamp
meta
viewcount
closed
DISTINCT
Number of rows per page :
Display order:
message_id
forum_id
thread
parent_id
author
subject
body
email
ip
status
msgid
modifystamp
user_id
thread_count
moderator_post
sort
datestamp
meta
viewcount
closed
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
message_id
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
forum_id
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
thread
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
parent_id
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
author
varchar(37)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
subject
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
body
text
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
email
varchar(100)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ip
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
status
tinyint(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
msgid
varchar(100)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
modifystamp
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
user_id
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
thread_count
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
moderator_post
tinyint(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
sort
tinyint(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
datestamp
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
meta
mediumtext
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
viewcount
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
closed
tinyint(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE