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) 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.... 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
Archived
This topic is now archived and is closed to further replies.