WHERE AND in Sqlite Statement

I am having a problem combining two WHERE statements in the following SQL statement :

query = [[NSString alloc] initWithFormat: @"SELECT Name, Description,Postcode,AddressLine1, ImageURL, Free, Area, OpeningTimes, NearestTube, Cost,UniqueID, URL, Number, FirstLetter FROM MainDetails WHERE Free ='Y' AND FirstLetter = '%@%'",tmpLike];

I want to say where Free is equal to Y and FirstLetter is equal to t开发者_JAVA技巧mplike, however the above is not working.

Can anyone help ?

Your using a wildcard so you want LIKE not equality (=);

... WHERE Free ='Y' AND FirstLetter LIKE '%@%'"

TRY THIS REMOVE % FROM LAST

query = [[NSString alloc] initWithFormat: @"SELECT Name, Description,Postcode,AddressLine1, ImageURL, Free, Area, OpeningTimes, NearestTube, Cost,UniqueID, URL, Number, FirstLetter FROM MainDetails WHERE Free ='Y' AND FirstLetter = '%@'",tmpLike];

try with escape char '/'

 query = [[NSString alloc] initWithFormat: @"SELECT Name, Description,Postcode,AddressLine1, ImageURL, Free, Area, OpeningTimes, NearestTube, Cost,UniqueID, URL, Number, FirstLetter FROM MainDetails WHERE Free ='Y' AND FirstLetter = '%@\%'",tmpLike];

use this one it work fine

query = [[NSString alloc] initWithFormat: @"SELECT Name, Description,Postcode,AddressLine1, ImageURL, Free, Area, OpeningTimes, NearestTube, Cost,UniqueID, URL, Number, FirstLetter FROM MainDetails WHERE Free ='Y' AND FirstLetter LIKE '%@ %%'",tmpLike];

Maybe simply brackets ?

... WHERE (Free ='Y') AND (FirstLetter LIKE '%@')",tmpLike];