英文:
Find a duplicated value from different columns in mySQL
问题
你想找到两列中具有重复文本的所有记录,以及了解除重复文本之外这两列中文本的总数。
英文:
I have a table with two text column, and I would like to find all the records that have duplicate text in this two columns. What is the best query I can use to find the duplicates?
and to understand the total number of texts in this two columns except duplicated.
答案1
得分: 1
以下是翻译的部分:
你可以通过以下SQL查询来实现。
select * from 表名 where 列1 == 列2
英文:
You can do by below sql query.
select * from tableName where column1 == column2
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论