MySQL where NOT IN名称数组

MySQL where NOT IN name array?

本文关键字：数组 IN where NOT MySQL | 更新日期: 2023-09-27

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

SELECT * FROM albums WHERE name NOT IN ???

我如何让它在数组中看起来，如果名称匹配，它应该匹配！=行

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

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