tomindo Posted December 22, 2010 Share Posted December 22, 2010 delete from users where email='(select email from users group by email having count(email) >1)' ; that is weird becaus the query does not work while the subquery works just fine Quote Link to comment https://forums.phpfreaks.com/topic/222347-query-acting-up/ Share on other sites More sharing options...
PFMaBiSmAd Posted December 22, 2010 Share Posted December 22, 2010 Remove the single-quotes that are around the sub-query. Quote Link to comment https://forums.phpfreaks.com/topic/222347-query-acting-up/#findComment-1150133 Share on other sites More sharing options...
tomindo Posted December 22, 2010 Author Share Posted December 22, 2010 I did that already. Any other idea? Quote Link to comment https://forums.phpfreaks.com/topic/222347-query-acting-up/#findComment-1150159 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.