On 13 Jan 2012, at 8:06am, Hajo Locke wrote: > 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%;
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' ? Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
