I'm wondering if is possible to use the "like" operator in a SQL query
For example, if I need only the records that start with given word,....
in sql should be (if i remember right):
select * from mytable where myfield like "sta"....
results: STAr, STAtement, STAring,.....
and in case "abc" is inside the record??? in sql I use %sta or %sta%
results: popSTAr, gangSTA, rockSTAr,......
this should be done in b4android????
For example, if I need only the records that start with given word,....
in sql should be (if i remember right):
select * from mytable where myfield like "sta"....
results: STAr, STAtement, STAring,.....
and in case "abc" is inside the record??? in sql I use %sta or %sta%
results: popSTAr, gangSTA, rockSTAr,......
this should be done in b4android????