SELECT * FROM studentinfo WHERE city <>'上海';
-- >!和=之间切勿用空格
SELECT * FROM studentinfo WHERE city != '上海';
08-12
1396
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
SELECT * FROM studentinfo WHERE city <>'上海';
-- >!和=之间切勿用空格
SELECT * FROM studentinfo WHERE city != '上海';