this is the output i want
"SELECT * FROM wateat_tbl where name like '%love%' or desc like '%love%'";
where *love is a text enter by user
now i want to write this in effective way right now i am doing this lame code
this is my lame code
Code:
myStringPrt1=@"SELECT * FROM wateat_tbl where name like '%";
NSString *trimmedString1 = [myStringPrt1 stringByTrimmingCharactersInSet:
[NSCharacterSet whitespaceAndNewlineCharacterSet]];
myStringPrt2=UserText;
NSString *myStringPrt3=@"%' or desc like '%";
NSString *myStringPrt4=@"%'";
trimmedString1=[trimmedString1 stringByAppendingString:myStringPrt2];
trimmedString1=[ trimmedString1 stringByAppendingString:myStringPrt3];
trimmedString1=[ trimmedString1 stringByAppendingString:myStringPrt2];
trimmedString1=[ trimmedString1 stringByAppendingString:myStringPrt4];
NSLog(@"My string is now = %@", trimmedString1);