IOS FMDB模糊查询实现

今天在做一个应用,需要实现数据库的模糊查询功能,在这里记录一下

 NSString *sql = [NSString stringWithFormat:@"SELECT * FROM TEST WHERE app like '%@%%'",keyword];//模糊查询，查找TEST中 以keyword开头的内容

  // NSString *sql = [NSString stringWithFormat:@"SELECT * FROM TEST WHERE app like '%%%@%%'",keyword];//模糊查询，查询TEST中包含keyword 的内容

  NSMutableArray *array = [NSMutableArray arrayWithCapacity:0];

  FMResultSet *rs = [fmdb executeQuery:sql];

while ([rs next])
{
      NSString * test = [rs stringForColumn:@"app"];
      NSLog(@"查询结果%@");
}