在SQLite查询中使用％并在ame引号内使用NSString变量 [英] using % inside SQLite query with an NSString variable inside the ame quotes

问题描述

这是我的代码:

NSString *vorStatement = [NSString stringWithFormat:@"SELECT * FROM vor WHERE ident like '%@%'",vorStringSearch];

我需要查询为"SELECT * FROM vor WHERE ident like'String％'"，但它不断删除最后一个％，因此查询最终为"SELECT * FROM vor WHERE ident like like'String'"尝试在％前面加上一个\，但不起作用...

I need to the query to be "SELECT * FROM vor WHERE ident like 'String%'" but it keeps dropping the last % in it so query ends up being "SELECT * FROM vor WHERE ident like 'String'" I tried putting a \ in front of the % and it doesnt work...

推荐答案

使用'%%'格式转义百分号.

Use '%%' format to escape percent symbol.

SELECT * FROM vor WHERE ident like '%@%%'

这篇关于在SQLite查询中使用％并在ame引号内使用NSString变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！