Top "Where-in" questions

An SQL-standard condition of the form WHERE SOME_COLUMN IN (1,2,3) or using a subquery to create the list, eg WHERE SOME_COLUMN IN (SELECT X FROM MYTABLE WHERE Y)

MySQL - SELECT WHERE field IN (subquery) - Extremely slow why?

I've got a couple of duplicates in a database that I want to inspect, so what I did to see …

mysql subquery where-in
Can I bind an array to an IN() condition?

I'm curious to know if it's possible to bind an array of values to a placeholder using PDO. The use …

php arrays pdo prepared-statement where-in
SQL use CASE statement in WHERE IN clause

Is it posible to use case in where in clause? Something like this: DECLARE @Status VARCHAR(50); SET @Status='published'; SELECT * …

sql select switch-statement case where-in
MySQL select join where AND where

I have two tables in my database: Products id (int, primary key) name (varchar) ProductTags product_id (int) tag_id (…

mysql join where-in relational-division
MySQL WHERE IN Query - ORDER BY Match

I'm trying to rephrase my question, cause my last one wasn't clear to everyone. This is my Test Table +----------+…

mysql sql sql-order-by where-in
NHibernate using QueryOver with WHERE IN

I would create a QueryOver like this SELECT * FROM Table WHERE Field IN (1,2,3,4,5) I've tried with Contains method but I've …

c# nhibernate queryover where-in
Where IN a Comma delimited string

I would like to retrieve certain users from a full list of a temp table #temptable. The query looks like …

sql-server delimiter where-in
MySQL multiple columns in IN clause

I have a database with four columns corresponding to the geographical coordinates x,y for the start and end position. …

mysql sql where-in
Passing multiple values for one SQL parameter

I have a CheckBoxList where users can select multiple items from the list. I then need to be able to …

sql-server-2005 tsql checkboxlist where-in
db2 query condition where column not in () while the column value is null

Good day, I have a row of data with a column, call status, the value inside is null. If I …

sql null db2 where-in