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