select where not in array from multiple values in table

Question

I have an array with some values. I want to retrieve something from a table where the values are not equal to the ones in the array

$myarray_example = array(1.1,2.5);

Table example:

So in this example I want to get only 3.10 value

The query

SELECT value FROM table 
WHERE value NOT IN ($myarray_example)

It returns everything. If I use 'WHERE value IN..' then it returns nothing.

Does anyone know why this happen?

Because by your example array, these look like string/varchar values, and 1.1 <> 1.10 and 2.5 <> 2.50, thus, you get every row. — Siyual
– Siyual, Commented Nov 16, 2016 at 17:03
Hello, just to clarify, I am passing numbers. It was just a mistake in my post. Both numbers in array and in table are float — giancy9
– giancy9, Commented Nov 16, 2016 at 17:04

lubilis · Accepted Answer · 2016-11-16 17:56:06Z

1

$query = " SELECT value FROM table ";
$query .= " WHERE value NOT IN ( ";

$count = 0;
foreach($myarray as $item) {
    $query .= $item;
    if ($count != count($myarray) - 1)
        $query .= ",";
    $count++;
}

$query .= ")";

edited Nov 16, 2016 at 17:56

answered Nov 16, 2016 at 17:07

lubilis

4,1704 gold badges33 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

giancy9 Over a year ago

Hello thanks. I have used something similar to what you just suggested and it works.

Collectives™ on Stack Overflow

select where not in array from multiple values in table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related