'phpmyadmin EXCEPT SELECT is not usable

I am trying to use EXCEPT when getting data from 2 tables, but I can not use EXCEPT SELECT.

Phpmyadmin does not recognize EXCEPT and does not allow me to use the 2nd SELECT.

Is there other way i can check for same entries on the tables?

EDIT: if t1 has rows:

id1-name1, id3-name3 

and t2 has:

id1-name1, id3-name3, id4-name4

then i would get a table with id4-name4 only (talking about rows)



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source