首页 ❯

MySQL 不在名称数组中？

php mysql sql
2022-08-30 10:16:09

我想排除这些专辑，它有名字：

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

我如何正确书写，

SELECT * FROM albums WHERE name NOT IN ???

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


答案 1

试试这个：

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

答案 2

MySQL代码是

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

推荐
更多 »
标签
更多 »
php pass-by-reference optional-parameters default-value javascript arrays dom function string object serialization tostring visibility syntax jslint use-strict operators equality equality-operator identity-operator datetime timestamp date-arithmetic redirect angularjs loops foreach iteration scope variables
推荐
更多 »