1.expr1 between expr2 and expr3:表示expr1的值在expr2和expr3之间
例子:$delete = "delete from user where id between 20 and 25";
2.expr1 in(expr2,expr3,expr4,…)表示expr1等于后面括号里面的任意一个表达式的值
例子:$delete = "delete from user where id in(20,25,30,28)";
1.expr1 between expr2 and expr3:表示expr1的值在expr2和expr3之间
例子:$delete = "delete from user where id between 20 and 25";
2.expr1 in(expr2,expr3,expr4,…)表示expr1等于后面括号里面的任意一个表达式的值
例子:$delete = "delete from user where id in(20,25,30,28)";
转载于:https://my.oschina.net/u/3887849/blog/1840902