[SOLVED] is that query possible?

[vmavrou]

Hi

i wanted to ask if i can use a query like this :

 

DELETE FROM groupspu WHERE (proistamenos && dokimi && public && admin) = '0'

 

because when i run it it deletes every row and not only the ones that the fields at the query are equal to zero.

 

It is important the certain format that's why i'm asking if this query is possible without altering the (proistamenos && dokimi && public && admin) . Because that info is taken from other place of the program.

 

Thanks in advance

[smerny]

(proistamenos && dokimi && public && admin)

 

I believe that would give True if they all exist, and False if one of them doesn't... and then compare True or False to '0'... and thats if the syntax was right

 

I think what you're trying to do is more like

 

proistamenos = '0' AND dokimi = '0' AND etc...

 

 

[vmavrou]

yep, it worked in this form :

 

DELETE FROM groupspu WHERE admin ='0' AND public ='0' AND dokimi ='0'  ...

 

Thanks alot!