Question

mysql语句如何一个字段不等于多少个值？

SELECT * FROM `ecs_volume_price` WHERE `goods_id` = '73' AND `volume_number` <> '4000'
我要`volume_number`不等于4000，8000，12000，16000，要怎么合并写？

Answer 1

SELECT * FROM `ecs_volume_price` WHERE `goods_id` = '73' AND `volume_number` not in(4000,8000,12000,16000)

Answer 2

volume_number not in (4000,8000,12000,16000)

Answer 3

是