Objective-C sqlite adding query parameter inside of LIKE clause
Put the %
characters into searchText
, like (excuse the pun) this:
const char *sql = "SELECT rowid, name, email FROM person WHERE name LIKE ?";sqlite3_stmt *sqlStatement;if(sqlite3_prepare_v2(db, sql, -1, &sqlStatement, NULL) != SQLITE_OK) { NSLog(@"Problem preparing getFilteredPeopleStubs statement.");}NSString *bindParam = [NSString stringWithFormat:@"%%%@%%", searchText];if(sqlite3_bind_text(sqlStatement, 1, [bindParam UTF8String], -1, SQLITE_TRANSIENT) != SQLITE_OK){ NSLog(@"Problem binding search text param.");}