Server:
mysql.puroparty.com
Database:
puroparty
Table:
ads_ads
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Select fields (at least one):
ad_id
ad_status
ad_user_id
ad_category
ad_date_begin
ad_date_end
ad_type
ad_title
ad_description
ad_image1
ad_image2
ad_image3
ad_image4
ad_image5
ad_options
ad_optional_1
ad_optional_2
ad_optional_3
ad_optional_4
ad_optional_5
ad_type_optional1
ad_type_optional2
ad_type_optional3
ad_type_optional4
ad_type_optional5
ad_type_optional6
ad_type_optional7
ad_type_optional8
ad_type_optional9
ad_type_optional10
ad_price
ad_condition
ad_views
ad_address
ad_city
ad_state
ad_postal
ad_country
ad_city_code
ad_state_code
ad_country_code
ad_fee
ad_anon_name
ad_anon_email
DISTINCT
Number of rows per page :
Display order:
ad_id
ad_status
ad_user_id
ad_category
ad_date_begin
ad_date_end
ad_type
ad_title
ad_description
ad_image1
ad_image2
ad_image3
ad_image4
ad_image5
ad_options
ad_optional_1
ad_optional_2
ad_optional_3
ad_optional_4
ad_optional_5
ad_type_optional1
ad_type_optional2
ad_type_optional3
ad_type_optional4
ad_type_optional5
ad_type_optional6
ad_type_optional7
ad_type_optional8
ad_type_optional9
ad_type_optional10
ad_price
ad_condition
ad_views
ad_address
ad_city
ad_state
ad_postal
ad_country
ad_city_code
ad_state_code
ad_country_code
ad_fee
ad_anon_name
ad_anon_email
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
ad_id
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
ad_status
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
ad_user_id
int(5)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
ad_category
int(5)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
ad_date_begin
varchar(10)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_date_end
varchar(10)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_type
tinyint(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
ad_title
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_description
text
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_image1
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_image2
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_image3
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_image4
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_image5
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_options
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
ad_optional_1
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_optional_2
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_optional_3
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_optional_4
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_optional_5
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_type_optional1
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_type_optional2
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_type_optional3
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_type_optional4
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_type_optional5
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_type_optional6
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_type_optional7
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_type_optional8
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_type_optional9
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_type_optional10
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_price
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_condition
tinyint(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
ad_views
int(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
ad_address
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_city
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_state
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_postal
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_country
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_city_code
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
ad_state_code
int(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
ad_country_code
int(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
ad_fee
float(6,2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
ad_anon_name
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
ad_anon_email
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP