Wildcards in SQL: https://www.w3schools.com/sql/sql_wildcards.asp <-- looking for something like that
Consider that I have a row with the string "John eats Apples" and I'm searching for rows which have "apples" in a specific column, I think wildcards would be the best for this. Please correct me if there is already such a method available.
PS: I am not using UCanAccess since I am working with fairly large databases and UCanAccess takes quite a few GBs of memory even after using the "memory=false" option with these databases.
Last edit: Xmair 2020-06-24
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
So that is not currently built in to jackcess. However, there are facilities for creating your own matching algorithm when doing lookups in cursors. You could very easily create a ColumnMatcher implementation which considered the search value a regex and did a regex matches() test on the given value.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
can you please provide some details as to what you are looking for?
Wildcards in SQL: https://www.w3schools.com/sql/sql_wildcards.asp <-- looking for something like that
Consider that I have a row with the string "John eats Apples" and I'm searching for rows which have "apples" in a specific column, I think wildcards would be the best for this. Please correct me if there is already such a method available.
PS: I am not using UCanAccess since I am working with fairly large databases and UCanAccess takes quite a few GBs of memory even after using the "memory=false" option with these databases.
Last edit: Xmair 2020-06-24
So that is not currently built in to jackcess. However, there are facilities for creating your own matching algorithm when doing lookups in cursors. You could very easily create a ColumnMatcher implementation which considered the search value a regex and did a regex matches() test on the given value.
Could I get an example?
So i decided to build in support for pattern matching. i just checked in PatternColumnPredicate which can do what you want. you can see examples of usage in PatternColumnPredicateTest.
changes will be in the 3.5.0 release.
Last edit: James Ahlborn 2020-06-27