FMDB 查询 where ..in..

最新推荐文章于 2019-07-24 18:27:05 发布

xak

最新推荐文章于 2019-07-24 18:27:05 发布

阅读量2.3k

点赞数

分类专栏： IOS开发文章标签： FMDB

本文链接：https://blog.csdn.net/cubesky/article/details/38754505

版权

IOS开发专栏收录该内容

78 篇文章 0 订阅

订阅专栏

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 Objects
NSString *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];