0

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.

Improve this question
0

1 Answer 1

Reset to default
1

You can do by below sql query.

 select * from tableName where column1 == column2
Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

null safe equal in mysql is <=> and op does not say test has to be on same row - so I'm surprised by the upvote

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.