Hi all, I'm trying to come up with an SQL statement that works under sqlite that can return a list of rows depending if a list of ids exist. For individual checking i'm using:
select 1 from table where id == 1; which returns a 1 if there is a row or no rows if it doesn't exist. However i have a large list to check and was trying to think of a way to optimise this. I can use: select 1 from table where id == 1 OR id == 2; which will return: 1 1 if they both exist, but if one doesn't exist i can't tell which one it is. Is there some way to get the statement to return a row with a 0 if the id doe not exist? 1 0 Or do i have to do the check for each one? Thanks for your help Andrew
