MySQL在哪里不在名字数组? [英] MySQL where NOT IN name array?

问题描述

我想排除这些名称为:

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

我如何正确书写

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

推荐答案

尝试一下:

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

这篇关于MySQL在哪里不在名字数组?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！