选择除几行拉里外的所有

Question

假设我有汽车桌，我有两列:型号，颜色。

  id      model       color
 ------  --------    ----------
   1      Ford           yellow
   2      Ford           green
   3      Ford           red
   4      Ford           yellow
   5      Subaru         yellow
   6      Subaru         red

我不想去福特汽车型号和黄色的地方。我怎样才能雄辩地做这件事。我需要这个条件。

WHERE NOT (model = 'Ford' AND color = 'yellow')

谢谢你的帮助

Answer 1

where('model', '!=', 'ford', 'AND', 'color', '!=', 'yellow')

Answer 2

只需使用!=操作符即可。

 WHERE (model != 'Ford' AND color != 'yellow')

Answer 3

试试这个..。

$products = Modelname::where('model','!=','Ford')->orwhere('color','!=','yellow')->get();

Its same as

SELECT * FROM tablename WHERE model != 'Ford' OR color != 'yellow';

​

​

输出：

Array ( [0] => Array ( [id] => 0 [model] => Ford [color] => green ) 

[1] => Array ( [id] => 0 [model] => Ford [color] => red ) 

[2] => Array ( [id] => 0 [model] => Subaru [color] => yellow ) 

[3] => Array ( [id] => 0 [model] => Subaru [color] => red ) )