通过FMDB将数组传递给sqlite WHERE IN子句？ [英] Passing an array to sqlite WHERE IN clause via FMDB?

问题描述

是否可以通过FMDB将数组传递给SELECT ... WHERE ... IN语句？
我试图像这样破坏数组：

  NSArray * mergeIds; //包含NSNumber对象的数组
 NSString * mergeIdString = [mergeIds componentsJoinedByString：@，]; 
 
 NSString * query = @SELECT * FROM items WHERE last_merge_id IN（？）; 
 FMResultSet * result = [database executeQuery：query，mergeIdString]; 
  

这只适用于数组中只有1个对象，这让我相信FMDB添加整个内爆字符串的引号。

所以我尝试将数组原样传递给FMDB的方法：

  NSArray * mergeIds; //带有NSNumber对象的数组
 NSString * query = @SELECT * FROM items WHERE last_merge_id IN（？）; 
 FMResultSet * result = [database executeQuery：query，mergeIds]; 
  

这根本不起作用。

<我在README或FMDB的github页面上没有找到任何关于它的信息。

谢谢，Stefan

解决方案

我创建了一个简单的FMDB扩展来解决问题：

GitHub上的FMDB + InOperator

Is it possible to pass an array to a SELECT … WHERE … IN statement via FMDB? I tried to implode the array like this:

NSArray *mergeIds; // An array with NSNumber Objects
NSString *mergeIdString = [mergeIds componentsJoinedByString:@","];

NSString *query = @"SELECT * FROM items WHERE last_merge_id IN (?)";
FMResultSet *result = [database executeQuery:query, mergeIdString];

This only works if there is exactly 1 object in the array, which leads me to believe that FMDB adds quotes around the whole imploded string.

So I tried passing the array as is to FMDB's method:

NSArray *mergeIds; // An array with NSNumber Objects
NSString *query = @"SELECT * FROM items WHERE last_merge_id IN (?)";
FMResultSet *result = [database executeQuery:query, mergeIds];

Which doesn't work at all.

I didn't find anything about it in the README or the samples on FMDB's github page.

Thanks, Stefan

解决方案

I created a simple FMDB extension to solve the problem:

FMDB+InOperator on GitHub

这篇关于通过FMDB将数组传递给sqlite WHERE IN子句？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！