Alex, I think this may be a solution: https://db.apache.org/derby/docs/10.14/tools/rtoolsoptlucene.html
On Mon, 30 Sep 2019 at 18:18, Alex O'Ree <alexo...@apache.org> wrote: > I have a use case where i have string data stored in a blob and i want to > perform a query similar to > > select * from table where column1 like '%hello world%' > > It doesn't look like this is possible with derby out of the box. Is there > a way to create a function that calls a java function or something that can > be used to make this work? >