search in mysql

[Cliffahoy]

Hi, what would I write in mysql database sql if I wanted to find a list of 50 email address from a list of 1000.

Otherwords how would I find the list of 50 to delete them?

The table is users and the field is email.

Thanks

[Pikachu2000]

If the 50 you want to delete are in an array, you can use DELETE FROM . . . WHERE . . . IN() syntax.

 

$query = "DELETE FROM `table` WHERE `email` IN( '" . implode("', '", $array_of_addresses) . "')";