Doctrine where not

Question

I have a table in DB like that

i want to select all except the record contain (x=1, y=1) i mean the 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

do want `x!=y` or just `x!=1` and `y!=1`? if `x!=1` and `y!=1` there is multiple `y=1` — hodl, Apr 01 '13 at 10:07
yeah, i want if y=1 and x = anything it's ok .... the only case i want to eliminate whe x=1 and y=1 — user1272589, Apr 01 '13 at 10:11
something like x=2 and y=1 ... it will not selected...right? — user1272589, Apr 01 '13 at 10:17

sandip · Accepted Answer · 2013-04-01T10:16:10.977

2

Try this: see the DEMO

select * from TableName where 1 NOT IN(x,y)

edited Apr 01 '13 at 10:16

answered Apr 01 '13 at 10:08

sandip

3,279
5
31
54

Sumit Bijvani · Answer 2 · 2013-04-01T10:13:11.183

1

Try this query

SELECT * FROM TableName where x!=1 OR y!=1

edited Apr 01 '13 at 10:13

answered Apr 01 '13 at 10:05

Sumit Bijvani

8,154
17
50
82

something like x=2 and y=1 ... it will not selected – user1272589 Apr 01 '13 at 10:09
ok now check my updated query, it will work... you can now get all the records where y=1 and x=anything – Sumit Bijvani Apr 01 '13 at 10:13
i want to select all record except the record contain (x=1, y=1) – user1272589 Apr 01 '13 at 10:14

score 1 · Answer 3 · answered Apr 01 '13 at 11:57

1

Following doctrine should work for you.

Doctrine_Query::Create() ->from("tablename") ->where("x != 1 AND Y != 1") ->fetchArray();

answered Apr 01 '13 at 11:57

Jaskaran Singh

2,392
24
39

score 0 · Answer 4 · answered Apr 01 '13 at 10:04

0

you can try this-

select * from TableName where x!=1 and y!=1

answered Apr 01 '13 at 10:04

Suresh Kamrushi

15,627
13
75
90

something like x=2 and y=1 ... it will not selected – user1272589 Apr 01 '13 at 10:09

score 0 · Answer 5 · answered Apr 01 '13 at 10:24

0

try this

 SELECT * FROM test where 1 NOT IN(x) OR 1 NOT IN (y)

see demo... http://www.sqlfiddle.com/#!2/dd008/12

answered Apr 01 '13 at 10:24

thumber nirmal

1,639
3
16
27

Doctrine where not

5 Answers5