Server:
mysql.puroparty.com
Database:
puroparty
Table:
photopost_photos
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Select fields (at least one):
id
user
userid
cat
storeid
storecat
date
title
description
keywords
bigimage
width
height
filesize
views
medwidth
medheight
medsize
approved
lastpost
rating
watermarked
allowprint
extra1
extra2
extra3
extra4
extra5
extra6
disporder
ipaddress
numcom
lastposter
lastpid
allowrate
allowcoms
DISTINCT
Number of rows per page :
Display order:
id
user
userid
cat
storeid
storecat
date
title
description
keywords
bigimage
width
height
filesize
views
medwidth
medheight
medsize
approved
lastpost
rating
watermarked
allowprint
extra1
extra2
extra3
extra4
extra5
extra6
disporder
ipaddress
numcom
lastposter
lastpid
allowrate
allowcoms
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
id
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
user
varchar(50)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
userid
int(8)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
cat
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
storeid
int(12)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
storecat
int(12)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
date
int(15)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
title
varchar(75)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
description
text
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
keywords
varchar(150)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
bigimage
varchar(100)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
width
smallint(6)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
height
smallint(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
filesize
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
views
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
medwidth
int(12)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
medheight
smallint(6)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
medsize
mediumint(9)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
approved
tinyint(2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
lastpost
int(15)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
rating
float(12,2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
watermarked
varchar(5)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
allowprint
varchar(5)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
extra1
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
extra2
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
extra3
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
extra4
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
extra5
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
extra6
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
disporder
int(5)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
ipaddress
varchar(32)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
numcom
int(8)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
lastposter
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
lastpid
int(8)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
allowrate
int(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
allowcoms
int(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE