Hello,
What did you want that command to actually do ? Are you searching for
short strings which occur in long strings ? Do you perhaps mean something
like
SELECT stringfield FROM mydb WHERE '%'||stringfield||'%' LIKE
'abcabcabcabc'
basically yes. i did not kew the '%'||xxx||'%' notation, i just tried
similar commands
But unfortunately it is not working. no error, but no dataset was found.
ahh, it works in reverse order:
SELECT stringfield FROM mydb WHERE 'abcabcabcabc' LIKE
'%'||stringfield||'%';
may be a speacial restriction of like-operator to have wildcardparts only on
right hand...
from performances point of view it should be ok to load pcre extension at
scriptstart and do the regexp. in all cases the strings are not very long.
doing dbi instead of exec will be the most cost saving factor.
Thank you,
Hajo
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
