Server:
mysql.puroparty.com
Database:
puroparty
Table:
photopost_users
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Select fields (at least one):
userid
usergroupid
username
password
email
homepage
icq
aim
yahoo
joindate
posts
birthday
ipaddress
location
interests
occupation
bio
site
offset
views
cellphone
DISTINCT
Number of rows per page :
Display order:
userid
usergroupid
username
password
email
homepage
icq
aim
yahoo
joindate
posts
birthday
ipaddress
location
interests
occupation
bio
site
offset
views
cellphone
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
userid
int(25)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
usergroupid
int(5)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
username
varchar(30)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
password
varchar(50)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
email
varchar(75)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
homepage
varchar(100)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
icq
varchar(50)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
aim
varchar(30)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
yahoo
varchar(30)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
joindate
int(25)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
posts
int(20)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
birthday
date
=
>
>=
<
<=
!=
LIKE
NOT LIKE
ipaddress
varchar(18)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
location
varchar(100)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
interests
varchar(250)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
occupation
varchar(250)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
bio
varchar(250)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
site
varchar(30)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
offset
smallint(2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
views
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
cellphone
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL