I want to get all the results but the ones in the array $valuesnew.
$query = "SELECT * FROM venue
WHERE venue_id IN ($valuesnew)";
Is there a fast way to do this?
$query = "SELECT * FROM venue
WHERE venue_id NOT IN ('".implode("','",$valuesnew)."')";
SELECT * ROM venue WHERE NOT venue_id ($valuesnew)
NOT Operator negates your condition.
Maybe:
$query = "SELECT * FROM venue
WHERE venue_id **NOT** IN ($valuesnew)";
select * from table where column NOT IN ('value1','value2','value3');