2010-06 coupon code:1006eb2s
SELECT * FROM s2 WHERE txtime > '2010/06' and txtime<'2010/07' AND not_ro != '1'
302x
====================================================================================
設非RO flag 
UPDATE `s2` SET not_ro='1' WHERE not (item1name like 'ro%' or item1name like '% ro%' or item1name like '%filte%' or item1name like '%osmosis%')
117664x
====================================================================================
Total
2005/02/20 02:12:57 -08:00 -> 2011/06/14 20:04:03 -07:00 
143318x
====================================================================================
非RO
SELECT item1name FROM `s2` WHERE not (item1name like 'ro%' or item1name like '% ro%' or item1name like '%filte%' or item1name like '%osmosis%')
117664x
====================================================================================
RO
SELECT txtime,createdate,fullname,email,itemcno,item1name,item1qty,sxtype FROM `s2` WHERE item1name like 'ro%' or item1name like '% ro%' or item1name like '%filte%' or item1name like '%osmosis%'
25654x