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

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

python - cx_oracle unable to find Oracle Client -