CODEWITHSUNDEEP
phpmysqlsqloperators
user2757862
user2757862

Reputation: 3

mysql multiple not operator for single column

Please how to MySql SELECT with multiple NOT operation for single column ?

Example:-

WHERE column != 'a' column != 'b' column != 'c'

Upvotes: 0

Views: 117

Answers (2)

calcinai
calcinai

Reputation: 2617

You could also use something with NOT IN()

WHERE column NOT IN ('a','b','c')

Upvotes: 1

Matthew
Matthew

Reputation: 9949

You are just missing AND

WHERE column != 'a' AND column != 'b' AND column != 'c'

Upvotes: 2

Related Questions