Server:
mysql.puroparty.com
Database:
puroparty
Table:
photopost_usergroups
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Select fields (at least one):
groupid
groupname
cpaccess
modaccess
uploads
comments
diskspace
uploadsize
uplimit
editpho
editposts
useralbums
reqmod
canassign
DISTINCT
Number of rows per page :
Display order:
groupid
groupname
cpaccess
modaccess
uploads
comments
diskspace
uploadsize
uplimit
editpho
editposts
useralbums
reqmod
canassign
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
groupid
int(5)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
groupname
varchar(50)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
cpaccess
smallint(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
modaccess
smallint(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
uploads
smallint(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
comments
smallint(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
diskspace
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
uploadsize
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
uplimit
int(5)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
editpho
int(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
editposts
int(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
useralbums
int(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
reqmod
int(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
canassign
int(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE