Select all but some lines

Question

let's say I have a table with this structure:

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

I need to make a request that returns me every car in the list, except ford's yellow. Can anyone help?

Answer 1

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

Answer 2

If you want to deselect some rows dynamically, you can use it:

 SELECT * FROM `table_1` WHERE id NOT IN (SELECT id FROM `table_2` WHERE column_name='value') 

NOTE. Here id is the column_name that has both tables.

Good luck. :)

Answer 3

In addition to Foo Bah's answer,

if you have null column values ​​such as:

 NAME COLOR Ford green Ford red Subaru yellow Subaru red Subaru NULL Ford NULL 

you need to use the ISNULL () function to output the values ​​of the null column

 ... WHERE NOT (ISNULL(NAME,'') = 'Ford' AND ISNULL(COLOR,'') = 'yellow') 

Answer 4

Use the color <> "yellow" and the model <> "Ford" as a where clause

Answer 5

Hope this helps you.

  $this->db->where('model !=','FORD' AND 'color!=','yellow'); $query= $this->db->get('table_name'); $res = $query->result_array(); return $res;