数据结构:
name shuxing date
lixiao 0(IPV6) 2011-01-01
lixiao 0(IPV4) 2011-01-01
lixiao 0 2011-01-01susan 20(IPV6) 2011-01-01
susan 20(IPV4) 2011-01-01
susan 20 2011-01-01sz 0+max(ss-2000)(IPV6) 2011-01-01
sz 0+max(ss-2000)(IPV4) 2011-01-01
sz 0+max(ss-2000) 2011-01-01
如何删除日期为2011-01-01号的,且shuxing的值里不包含(IPV6),(IPV4)的记录,我要的结果是:name shuxing date
lixiao 0(IPV6) 2011-01-01
lixiao 0(IPV4) 2011-01-01susan 20(IPV6) 2011-01-01
susan 20(IPV4) 2011-01-01sz 0+max(ss-2000)(IPV6) 2011-01-01
sz 0+max(ss-2000)(IPV4) 2011-01-01
name shuxing date
lixiao 0(IPV6) 2011-01-01
lixiao 0(IPV4) 2011-01-01
lixiao 0 2011-01-01susan 20(IPV6) 2011-01-01
susan 20(IPV4) 2011-01-01
susan 20 2011-01-01sz 0+max(ss-2000)(IPV6) 2011-01-01
sz 0+max(ss-2000)(IPV4) 2011-01-01
sz 0+max(ss-2000) 2011-01-01
如何删除日期为2011-01-01号的,且shuxing的值里不包含(IPV6),(IPV4)的记录,我要的结果是:name shuxing date
lixiao 0(IPV6) 2011-01-01
lixiao 0(IPV4) 2011-01-01susan 20(IPV6) 2011-01-01
susan 20(IPV4) 2011-01-01sz 0+max(ss-2000)(IPV6) 2011-01-01
sz 0+max(ss-2000)(IPV4) 2011-01-01
select * from table where date='2011-01-01' and shuxing not like '%(IPV6)%' and shuxing not like '%(IPV6)%'
不知是否可行