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.

Jexi
  • 1
  • 1

1 Answers1

1

You can do by below sql query.

 select * from tableName where column1 == column2
Pintu Parikh
  • 11
  • 2
  • 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 – P.Salmon Apr 10 '23 at 11:57