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 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. 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? Link to comment https://forums.phpfreaks.com/topic/222347-query-acting-up/#findComment-1150159 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.