where id ='参数' and (grade = '2' or name like '%参数%')加个括号就可以了
select * from T where id ='参数' and (grade = "2" or name like"%参数%")问题有点不理解。是不是这样select * from T where (grade = '2' or name like '%'+id+'%')
