数据源
字段为mm1
AddRegion
AlongPath
AlongPath
AlongPath
@"AddRegion","Rotate3D"
现在查询的方法是
select * from table where mm1 like '%AddRegion%'
查询结果为两条记录
AddRegion
@"AddRegion","Rotate3D"
目标需求
记录包含"@"和"AddRegion"的记录.
查询结果为
@"AddRegion","Rotate3D"
而
AddRegion记录不要
字段为mm1
AddRegion
AlongPath
AlongPath
AlongPath
@"AddRegion","Rotate3D"
现在查询的方法是
select * from table where mm1 like '%AddRegion%'
查询结果为两条记录
AddRegion
@"AddRegion","Rotate3D"
目标需求
记录包含"@"和"AddRegion"的记录.
查询结果为
@"AddRegion","Rotate3D"
而
AddRegion记录不要
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货