Question on sqlite query with regular expression

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

Question on sqlite query with regular expression

Postby powerdeng » Mon Feb 16, 2009 10:26 am

Is there any way out to achieve
"SELECT * FROM tblname
WHERE name LIKE '%[0-9]%' "

i know we can't do this with sqlite~
but how to deal with such query task with sqlite???


i tried to use REGEXP ~but unluckily it is not pre-defined~
so i tried to define it by myself...but even i couldn't find a way in
android to create a UserDefinedFunction...

thx~
powerdeng
Freshman
Freshman
 
Posts: 9
Joined: Mon Feb 16, 2009 10:20 am
Location: Chengdu,China

Top

Return to Networking & Database Problems

Who is online

Users browsing this forum: No registered users and 10 guests