mysql - 匹配mySQL中两条记录中的值

Question

如何匹配mysql中两条记录的一列中的逗号分隔值

我有两条记录，例如

请检查此屏幕截图: https://www.dropbox.com/s/x1g51fy7hcwun33/ques.jpg

我真正想要的是两条记录中values_array 列上匹配值的数量。或者只是两条记录中匹配的值。

喜欢

ma​​tch_value_count

5

提前致谢

Answer 1

我已经找到了解决方案，因此我与也在寻找它的每个人分享..

SELECT `engine4_users`.*, COUNT(value) AS `count` FROM `engine4_users`
INNER JOIN `engine4_user_fields_values` ON engine4_user_fields_values.item_id = engine4_users.user_id WHERE (engine4_users.user_id NOT IN (4)) AND (engine4_users.user_id != 1) AND (engine4_user_fields_values.value IN ('1', 'Mubasher ', 'Munir', '2', '1993-6-29', 'Lahore', '54000', '5', '10', 'Video Gaming', 'Transporter ', 'OOP', 'Akcent', 'Star Movies', '1', '21', '2010-1-2', 'nothing', '', '2012-1-4', 'Nothing', 'Others', '22', 'Nothing')) GROUP BY `item_id` HAVING (count(value) > 1) ORDER BY `count` DESC

引用图片 https://www.dropbox.com/s/28w9uckvar9uvf1/answ.jpg