MySQL where NOT IN name array?

I would like to exclude these albums, that has name:

$ban_album_names = array('Wall', 'Profile', 'Cover', 'Instagram');

How do I write correctly,

SELECT * FROM albums WHERE name NOT IN ???

How can I make it look in the array, and if the name matches it should != the row

Try this:

$sql = "SELECT *
    FROM albums
    WHERE name NOT IN ( '" . implode( "', '" , $ban_album_names ) . "' )";

The MySQL CODE is

SELECT * FROM albums WHERE name NOT IN ('Wall', 'Profile', 'Cover', 'Instagram')

Related