需求:数据需过滤掉:name = ‘张三’ and age = ‘20’ 的数据;
SQ语法:
1.select * from table where (name != '张三' or age != '20')
2.select * from table where not(name = '张三' and age = '20')
MyBatis语法:{name}和{age}均为入参带入:如:name == “张三” ,age == “20”
1.select * from table where (name <![CDATA[ <> ]]> #{name} or age <![CDATA[ <> ]]> #{age})
2.select * from table where not(name = #{name} and age = #{age})