php - Doctrine where not -
i have table in db
i want select except record contain (x=1, y=1) mean id=8
id | x | y --------------- 1 | 2 | 1 2 | 0 | 1 3 | 5 | 6 4 | 6 | 4 5 | 7 | 4 6 | 7 | 4 7 | 5 | 7 8 | 1 | 1
try this: see demo
select * tablename 1 not in(x,y)
Comments
Post a Comment