今天在做一個應(yīng)用,需要實(shí)現(xiàn)數(shù)據(jù)庫的模糊查詢功能,在這里記錄一下
NSString *sql = [NSString stringWithFormat:@"SELECT * FROM TEST WHERE app like '%@%%'",keyword];//模糊查詢，查找TEST中 以keyword開頭的內(nèi)容
// NSString *sql = [NSString stringWithFormat:@"SELECT * FROM TEST WHERE app like '%%%@%%'",keyword];//模糊查詢，查詢TEST中包含keyword 的內(nèi)容
NSMutableArray *array = [NSMutableArray arrayWithCapacity:0];
FMResultSet *rs = [fmdb executeQuery:sql];
while ([rs next])
{
NSString * test = [rs stringForColumn:@"app"];
NSLog(@"查詢結(jié)果%@");
}
