2.select * from Table where UserCode='010037' --直接查询出
select * from Table where UserCode Like '%010%' and UserCode='010037'
应该没什么区别的,SQL引擎看到第2句where子句有UserCode='010037',会自动先去找UserCode的索引来用,然后再判断UserCode Like '%010%'.即"条件1 and 条件2" 等价于 "条件2 and 条件1". 但一般不建议这么写: UserCode Like '%010%'