·ĒRO
SELECT txtime,createdate,fullname,email,itemcno,item1name,item1qty,sxtype FROM `s2` WHERE not (item1name like '% ro%' or item1name like '% ro+%' or item1name like '%filter%' or item1name like '%osmosis%')
RO
SELECT txtime,createdate,fullname,email,itemcno,item1name,item1qty,sxtype FROM `s2` WHERE item1name like '% ro%' or item1name like '% ro+%' or item1name like '%filter%' or item1name like '%osmosis%'