this is the output i want "SELECT * FROM wateat_tbl where name like '%love%' or desc like '%love%'";
where *love is a text enterted by use*r now i want to write this in effective way right now i am doing this lame code
myStringPrt1=@"SELECT * FROM wateat_tbl where name like '%"
NSString *trimmedString1 = [myStringPrt1 stringByTrimmingCharactersInSet:
[NSCharacterSet whitespaceAndNewlineCharacterSet]];
myStringPrt2=UserText;// user input LOVE
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);