iphone - 就像sqlite中的查询一样

Question

NSString * strSearchSql = [NSString stringWithFormat:@"SELECT pdf_id,pdf_name,page_no,pdf_image,pdf_text FROM search WHERE pdf_text LIKE '\%%@\%'",strSearchString];

在这个查询中我得到了类似的字符串下面给出

SELECT pdf_id,pdf_name,page_no,pdf_image,pdf_text FROM search WHERE pdf_text LIKE '%@'

我想要这样

SELECT pdf_id,pdf_name,page_no,pdf_image,pdf_text FROM search WHERE pdf_text LIKE '%searchtext%'

请给我提示或向我提供文件。

Answer 1

转义查询中的 % 符号，例如 %% 而不是 \%。

NSString *strSearchSql = [NSString stringWithFormat:@"SELECT pdf_id,pdf_name,page_no,pdf_image,pdf_text FROM search WHERE pdf_text LIKE '%%%@%%'", strSearchString];