Find and remove duplicates: Difference between revisions
Jump to navigation
Jump to search
→Finding duplicate value that differ in one column
| Line 66: | Line 66: | ||
</pre> | </pre> | ||
'''Another approach:''' Add {{kbd | key=content_hash}} column which its value is {{kbd | key=MD5(content_column)}} | '''Another approach:''' Add {{kbd | key=content_hash}} column which its value is {{kbd | key=MD5(content_column)}}<ref>[https://errerrors.blogspot.com/2023/08/how-to-find-duplicate-text-values-in-mysql.html MySQL 如何尋找重複的文章 (文字類型資料)]</ref> | ||
<pre> | <pre> | ||