compare columns

Here is how to compare two columns in MySQL. You can compare two columns from same table or from different table.