Server:
mysql.puroparty.com
Database:
puroparty
Table:
jos_session
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Select fields (at least one):
username
time
session_id
guest
userid
usertype
gid
client_id
data
DISTINCT
Number of rows per page :
Display order:
username
time
session_id
guest
userid
usertype
gid
client_id
data
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
username
varchar(150)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
time
varchar(14)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
session_id
varchar(200)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
guest
tinyint(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
userid
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
usertype
varchar(50)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
gid
tinyint(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
client_id
tinyint(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
data
longtext
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL