Server:
mysql.puroparty.com
Database:
puroparty
Table:
bos_categories
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Select fields (at least one):
category_id
category_order
category_parent
category_title
category_desc
category_img
category_ad_types
category_ad_prices
category_optional_1
category_optional_1_def
category_optional_2
category_optional_2_def
category_optional_3
category_optional_3_def
category_optional_4
category_optional_4_def
category_optional_5
category_optional_5_def
category_subs
category_listings
banner_top
banner_bottom
category_related
DISTINCT
Number of rows per page :
Display order:
category_id
category_order
category_parent
category_title
category_desc
category_img
category_ad_types
category_ad_prices
category_optional_1
category_optional_1_def
category_optional_2
category_optional_2_def
category_optional_3
category_optional_3_def
category_optional_4
category_optional_4_def
category_optional_5
category_optional_5_def
category_subs
category_listings
banner_top
banner_bottom
category_related
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
category_id
int(5)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
category_order
int(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
category_parent
int(5)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
category_title
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
category_desc
text
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
category_img
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
category_ad_types
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
category_ad_prices
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
category_optional_1
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
category_optional_1_def
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
category_optional_2
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
category_optional_2_def
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
category_optional_3
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
category_optional_3_def
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
category_optional_4
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
category_optional_4_def
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
category_optional_5
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
category_optional_5_def
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
category_subs
int(5)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
category_listings
int(5)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
banner_top
varchar(5)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
banner_bottom
varchar(5)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
category_related
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP