FMDB 查询 where ..in..

1、已知查找值的个数

NSString *getDataSql = @"SELECT * FROM data WHERE dataID IN (?, ?,?)";Then use the executeQuery:withArgumentsInArray call:FMResultSet *results = [database executeQuery:getDataSqlwithArgumentsInArray:dataIDs];

2、未知查找值的个数

2.1、对于查找值为NSNumber

NSArray *mergeIds; // An array of NSNumber ObjectsNSString *mergeIdString = [mergeIds componentsJoinedByString:@","]; NSString *query = @"SELECT * FROM items WHERE last_merge_id IN (?)"; FMResultSet *res = [self.database executeQueryWithFormat:query, mergeIdString];

2.1、对于查找值为NSString

NSString * strComma = [strArray componentsJoinedByString:@"", ""]; NSString * sql = [NSString stringWithFormat:@"SELECT * FROM tableName WHERE fieldName IN ("%@")", strComma];