such query is possible in mysql? - HTML Forums

vasmav · 11-19-2009, 02:26 PM

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 withou altering the (proistamenos && dokimi && public && admin) . Because that info is taken from other place of the program.

Thanks in advance

¥åßßå · 11-19-2009, 02:35 PM

DELETE FROM your_table WHERE foo='0' AND bar='0' AND 'hello_world' = '0' != ( foo == true && bar == true && hello_world == true ) == 0 ?

¥

vasmav · 11-19-2009, 02:48 PM

Thanks for your help, manage to fix it by altering the part that i couldn't..

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

made it like that and worked!

Thanks alot for your answer!