java - Query Android's SQLiteDatabase using Regex -
i trying fetch entries sqlitedatabase in android program using query function using selection parameter. have had success simple pattern matching using sqlite's , % wildcard. want more complex pattern matching using regular expressions.
according sqlite website, regexp operator function, must user defined. has had success creating use defined sqlite functions android's sqlitedatabase? or has found way use regular expressions when searching through strings in database?
as described here
the regexp operator special syntax regexp() user function. no regexp() user function defined default , use of regexp operator result in error message. if application-defined sql function named "regexp" added @ run-time, function called in order implement regexp operator.
but there glob little more advanced like.
Comments
Post a Comment