Does SQLiteDatabase support LIKE pattern?

Problems with WiFi, SQLite ,Bluetooth, WiMax, Proxies, etc...

Does SQLiteDatabase support LIKE pattern?

Postby ddtdpro » Thu Jul 09, 2009 7:30 am

Hi plusminus,

I have 1 query about the LIKE pattern in the SQL syntax, does the SQLite support that? If yes, how can i query that, can you give me an simple example code how to do that?

Thank you very much.
ddtdpro
User avatar
ddtdpro
Freshman
Freshman
 
Posts: 6
Joined: Sat May 02, 2009 5:39 pm

Top

Postby serkan.dogantekin » Thu Jul 09, 2009 8:40 am

according to the sqlite documentation, "like" expressions are valid and can be called as :

....where x like '%abc%'

is this not working in your case???
serkan.dogantekin
Developer
Developer
 
Posts: 27
Joined: Thu Jun 04, 2009 6:12 pm
Location: Istanbul/Turkey

Postby ddtdpro » Thu Jul 09, 2009 4:40 pm

serkan.dogantekin wrote:according to the sqlite documentation, "like" expressions are valid and can be called as :

....where x like '%abc%'

is this not working in your case???


I know the syntax, but the thing is i don't know how to use it. I tried use rawQuery, but it always has error, i don't know how.
User avatar
ddtdpro
Freshman
Freshman
 
Posts: 6
Joined: Sat May 02, 2009 5:39 pm

Postby nmc » Thu Jul 09, 2009 6:41 pm

Using rawQuery() with "like" statements works just fine.
Post some code if you want help 8)
nmc
Senior Developer
Senior Developer
 
Posts: 154
Joined: Thu Nov 27, 2008 8:30 pm
Location: Germany

Top

Return to Networking & Database Problems

Who is online

Users browsing this forum: Google Feedfetcher and 7 guests