What is the usage of “intersect” in MySQL?

MySQL does not directly support the intersect operator. However, a similar effect can be achieved by using subqueries and INNER JOIN.

For example, suppose we have two tables table1 and table2, we can use the following query to achieve the effect of intersect, which retrieves the common rows between the two tables:

SELECT * FROM table1
INNER JOIN table2
ON table1.column1 = table2.column1
AND table1.column2 = table2.column2;

This allows for obtaining rows common to both tables. This method replicates the effect of the intersect operator.