masscrazy Posted February 4, 2008 Share Posted February 4, 2008 So i have a SINGLE table with user track and rating columns. I have say 11 records 5 records by 1 user and 6 by the other. I need to know if both have rated the the same tracks and count if any are different or not, so if they both rated the same tracks then only 1 would be counted as different since the 11th record hasnt been rated by one user. if i have sets(user, track) a(1,2,3) b(1,2,3) and count the difference, it should be 0 since there is not difference and if the sets a(1,2,3) b(1,2,3,4) the number should be 1 for there is only 1 different to set a. How would i represent this in mysql. (check thttp://forums.mysql.com/read.php?52,121807,121807#msg-121807 and its replies, it might help you to answer the question) Quote Link to comment https://forums.phpfreaks.com/topic/89300-comparing-a-single-tables-records-to-find-number-of-differences/ Share on other sites More sharing options...
fenway Posted February 4, 2008 Share Posted February 4, 2008 You could left join and get the difference between the counts.... Quote Link to comment https://forums.phpfreaks.com/topic/89300-comparing-a-single-tables-records-to-find-number-of-differences/#findComment-457558 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.