I'm looking for a way to use NSPredicate
to set a LIKE
condition to fetch objects. In addition to that, an OR
would be useful as well. I'm trying to do something where if a user searches "James" I can write an NSPredicate
that will do the equivalent of:
select * from users where firstname LIKE '%James%' OR lastname LIKE '%James%';
NSString *_mySearchKey = @"James";
NSPredicate *_myPredicate = [NSPredicate predicateWithFormat:@"(firstname CONTAINS[cd] %@) OR (lastname CONTAINS[cd] %@)", _mySearchKey, _mySearchKey];