03-11-2012 05:54 AM
i'm struggling to execute this kind of sql statement in sqlite with blackberry:
SELECT * FROM client WHERE name LIKE '%bla%'
the LIKE used with % string % for specifying that you want results with "bla" included in the name doesn't work. can someone help me or give me an alternative? thx
Solved! Go to Solution.
03-11-2012 02:18 PM
08-07-2012 08:53 AM
Statement statement = _db.createStatement("SELECT * FROM Messages WHERE Message like '%" + Query + "%' AND Category LIKE '%" + Category+ "%' AND Favourite LIKE '%" + Favourite+ "%'");
This is the solution to my problem... i completly forgot to add it... sorry for the delay