Server:
mysql.puroparty.com
Database:
puroparty
Table:
bosdevUUS
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Select fields (at least one):
id
username
password
email
status
last_login
bd1
bd2
bd3
bd4
bd5
bc1
bc2
bc3
bc4
bc5
bdir1
bdir2
bdir3
bdir4
bdir5
bm1
bm2
bm3
bm4
bm5
bn1
bn2
bn3
bn4
bn5
bf1
bf2
bf3
bf4
bf5
bdl
extraFName
extraLName
extraAddr1
extraAddr2
extraCity
extraState
extraPostal
extraHPhone
extraMPhone
DISTINCT
Number of rows per page :
Display order:
id
username
password
email
status
last_login
bd1
bd2
bd3
bd4
bd5
bc1
bc2
bc3
bc4
bc5
bdir1
bdir2
bdir3
bdir4
bdir5
bm1
bm2
bm3
bm4
bm5
bn1
bn2
bn3
bn4
bn5
bf1
bf2
bf3
bf4
bf5
bdl
extraFName
extraLName
extraAddr1
extraAddr2
extraCity
extraState
extraPostal
extraHPhone
extraMPhone
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
id
int(5)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
username
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
password
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
email
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
status
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
last_login
date
=
>
>=
<
<=
!=
LIKE
NOT LIKE
bd1
tinyint(2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
bd2
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bd3
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bd4
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bd5
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bc1
tinyint(2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
bc2
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bc3
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bc4
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bc5
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bdir1
tinyint(2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
bdir2
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bdir3
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bdir4
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bdir5
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bm1
tinyint(2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
bm2
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bm3
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bm4
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bm5
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bn1
tinyint(2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
bn2
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bn3
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bn4
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bn5
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bf1
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bf2
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bf3
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bf4
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bf5
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
bdl
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
extraFName
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
extraLName
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
extraAddr1
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
extraAddr2
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
extraCity
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
extraState
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
extraPostal
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
extraHPhone
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
extraMPhone
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP