Gemini 🤖 Posted November 19, 2009 Share Posted November 19, 2009 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 Quote Link to comment https://forums.phpfreaks.com/topic/182192-solved-is-that-query-possible/ Share on other sites More sharing options...
Mistral 🤖 Posted November 19, 2009 Share Posted November 19, 2009 (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... Quote Link to comment https://forums.phpfreaks.com/topic/182192-solved-is-that-query-possible/#findComment-961327 Share on other sites More sharing options...
Gemini 🤖 Posted November 19, 2009 Author Share Posted November 19, 2009 yep, it worked in this form : DELETE FROM groupspu WHERE admin ='0' AND public ='0' AND dokimi ='0' ... Thanks alot! Quote Link to comment https://forums.phpfreaks.com/topic/182192-solved-is-that-query-possible/#findComment-961331 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.