Using % Inside Sqlite Query With An Nsstring Variable Inside The Ame Quotes

Here's my code: NSString *vorStatement = [NSString stringWithFormat:@'SELECT * FROM vor WHERE ident like '%@%'',vorStringSearch]; I need to the query to be 'SELECT * FROM vor WHER

Solution 1:

Use '%%' format to escape percent symbol.

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