143318 設非RO flag 117664 UPDATE `s2` SET not_ro='1' WHERE not (item1name like 'ro%' or item1name like '% ro%' or item1name like '%filte%' or item1name like '%osmosis%') 非RO 117664 SELECT item1name FROM `s2` WHERE not (item1name like 'ro%' or item1name like '% ro%' or item1name like '%filte%' or item1name like '%osmosis%') RO 25654 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%'