Server:
mysql.puroparty.com
Database:
puroparty
Table:
bos_coupons
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Select fields (at least one):
coupon_id
coupon_code
coupon_percent
coupon_amount
coupon_expires
coupon_uses
coupon_restrict
coupon_type
DISTINCT
Number of rows per page :
Display order:
coupon_id
coupon_code
coupon_percent
coupon_amount
coupon_expires
coupon_uses
coupon_restrict
coupon_type
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
coupon_id
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
coupon_code
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
coupon_percent
tinyint(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
coupon_amount
float(6,2)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
coupon_expires
date
=
>
>=
<
<=
!=
LIKE
NOT LIKE
coupon_uses
int(5)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
coupon_restrict
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
coupon_type
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE