Hello,
On the other hand, it looks like all that extension does is implement some
regex stuff, and you might be able to do what you want to do with SQLite's
"LIKE" operator.
hmm, like operator would be the 1st choice, but this is not working in my
case.
in my db-field there are always just short strings like:
stringfield
---------
abc
acd
bac
bca
the string which i get from script is in most cases much longer.
so i was not successful when selecting this way:
select stringfield from mydb where stringfield like '%abcabcabcabc%;
it just works after using regexp this way:
select stringfield from mydb where 'abcabcabcabc' regexp stringfield;
i did not found a solution using like-operator, so i did it with regexp.
like Stephan Beal suggested the >>select
load_extension("/usr/lib/sqlite3/pcre.so");<< is working. with perl-dbi.
so i think i will go this way.
Thanks,
Hajo
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
