mysql - How to Isolate a list of records that don't exist in the database -

i trying select database 4000+ records , realize 800 of them not in database.

the following query returns 3 rows (emails) , 1 of them not on database yet, there way can list of not on database ?

select email email_list email in ('email1@test.com', 'email2@test.com', 'email3@test.com', 'email4@test.com');

thanks

use not exist in clause:

...where not exists (query_to_get_the_unwanted_records)