Server:
mysql.puroparty.com
Database:
puroparty
Table:
bos_ad_types
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Select fields (at least one):
type_id
type_title
type_required
type_use
option1
def_option1
option2
def_option2
option3
def_option3
option4
def_option4
option5
def_option5
option6
def_option6
option7
def_option7
option8
def_option8
option9
def_option9
option10
def_option10
template
DISTINCT
Number of rows per page :
Display order:
type_id
type_title
type_required
type_use
option1
def_option1
option2
def_option2
option3
def_option3
option4
def_option4
option5
def_option5
option6
def_option6
option7
def_option7
option8
def_option8
option9
def_option9
option10
def_option10
template
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
type_id
tinyint(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
type_title
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
type_required
int(6)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
type_use
int(6)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
option1
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
def_option1
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
option2
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
def_option2
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
option3
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
def_option3
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
option4
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
def_option4
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
option5
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
def_option5
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
option6
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
def_option6
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
option7
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
def_option7
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
option8
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
def_option8
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
option9
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
def_option9
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
option10
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
def_option10
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
template
mediumtext
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP