php - 在 Mysql 中不起作用

Question

我正在尝试使用 NOT 函数从表 Projects 运行 Sql。但它给出了语法错误，期望的结果是从表 projects 中获取所有数据，除了 coloumn_2 中的值是 image

Coloumn_1 Coloumn_2 Coloumn_3  Type 
2335      Image     Value 1    Single
2335      Name 2    Value 2    NULL 
2346      Name 3    Value 3    MULTI
2234      Name 4    Value 4    Single
2235      Name 5    Value 5    Single

这是当前使用的函数

public function get_all_projects()
{
    $params = array( ':affiliate_id' => $_SESSION['jigowatt']['user_id']);
    $sql = "SELECT * FROM Projects AND NOT (coloumn_2 = 'image')";
    $stmt = parent::query($sql, $params);
    while($row = $stmt->fetch(PDO::FETCH_ASSOC)) :
        $projects[] = $row;
    endwhile;
    return $projects;
}

Answer 1

desired result is to get all data from table projects except where value in coloumn_2 is image

这个查询可能会给你想要的结果。

$sql = "SELECT * FROM Projects WHERE coloumn_2 != 'image'";