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...
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
2 Answers
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')
Alexander Ross has covered the video game industry for a decade, writing deep dives on game design, esports tournaments, VR developments, and gaming culture.
