Hi! I put this together for a partial Lucene search. If you don’t find a flaw in it, use it and say it. :)
If it’s not good or there’s a better solution, I still look forward to your feedback! thx, mps SELECT SUBSTRING(FTR.KEY,6) AS KEY,FTI."SCHEMA", FTI."TABLE",FTS."NAME" AS SEARCH_RESULT FROM FT.WORDS FTS JOIN FT.MAP FTM ON FTM.WORDID = FTS.ID JOIN FT."ROWS" FTR ON FTR.ID = FTM.ROWID JOIN FT.INDEXES FTI ON FTI.ID = FTR.INDEXID WHERE FTS.NAME LIKE '%FOOBAR%' ORDER BY FTI."TABLE" -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/3b528cfd-aa81-4fb4-88b3-b178ac40076en%40googlegroups.com.
