Server:
mysql.puroparty.com
Database:
puroparty
Table:
photopost_categories
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Select fields (at least one):
id
catname
description
catorder
thumbs
parent
header
footer
headtags
private
ugnoview
ugnoupload
ugnopost
ugnovote
ugnoanno
children
albums
subalbum
lastpost
lastphoto
photos
posts
password
cattype
theme
thumbtype
catdepth
watermark
sortorder
extra1
extra2
extra3
extra4
extra5
extra6
thumbnail
maximages
canzip
frames
intro
introtitle
introcopy
moderators
numextra
ratingtype
takevotes
ismember
DISTINCT
Number of rows per page :
Display order:
id
catname
description
catorder
thumbs
parent
header
footer
headtags
private
ugnoview
ugnoupload
ugnopost
ugnovote
ugnoanno
children
albums
subalbum
lastpost
lastphoto
photos
posts
password
cattype
theme
thumbtype
catdepth
watermark
sortorder
extra1
extra2
extra3
extra4
extra5
extra6
thumbnail
maximages
canzip
frames
intro
introtitle
introcopy
moderators
numextra
ratingtype
takevotes
ismember
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
id
int(12)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
catname
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
description
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
catorder
mediumint(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
thumbs
varchar(4)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
parent
int(5)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
header
varchar(200)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
footer
varchar(200)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
headtags
varchar(200)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
private
varchar(5)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ugnoview
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
ugnoupload
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
ugnopost
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
ugnovote
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
ugnoanno
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
children
text
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
albums
text
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
subalbum
int(12)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
lastpost
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
lastphoto
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
photos
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
posts
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
password
varchar(24)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
cattype
varchar(4)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
theme
varchar(32)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
thumbtype
int(2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
catdepth
varchar(6)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
watermark
varchar(250)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
sortorder
int(2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
extra1
varchar(250)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
extra2
varchar(250)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
extra3
varchar(250)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
extra4
varchar(250)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
extra5
varchar(250)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
extra6
varchar(250)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
thumbnail
int(15)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
maximages
int(12)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
canzip
char(3)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
frames
varchar(32)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
intro
char(3)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
introtitle
varchar(128)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
introcopy
text
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
moderators
text
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
numextra
int(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
ratingtype
int(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
takevotes
int(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
ismember
smallint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE