如何在sql查询中处理数组值

Question

I have a personID array like this (123,456,789,etc...) What I want to do is to query like this SELECT * FROM tblperson WHERE personID <> '123' or personID <> '456' or personID <> '789'

Note that the personID i want to get is from dynamic array. Thanks!

Answer 1

Use not in

SELECT * FROM tblperson WHERE personID not in ( 123 ,456 , 789)

As you are using javascript, try below code to generate your query

var ids = [123 ,456 , 789];
var query = 'SELECT * FROM table WHERE id not IN (' + ids.join() + ')';