I'm certain this is a really easy question. I'm new to mysql. 

I need to find all emails in a list that i have. 

The list is about 40 emails.

```
this@gmail.com
that@gmail.com
another@gmail.com
onemore@gmail.com

```

I've tried this:

```
    SELECT * FROM `sales_flat_order` WHERE customer_email = "'this@gmail.com',     'this@gmail.com'"

    SELECT * FROM `sales_flat_order` WHERE customer_email = "this@gmail.com, this@gmail.com"

    SELECT * FROM `sales_flat_order` WHERE customer_email in(this@gmail.com, this@gmail.com)

```

and various other queries. any help would be appreciated.