[firebird-support] How to do a full text search ?

[nathanelrick]

Hello,

We have a table where user can do classic search against different field

select 
  ... 
from 
  tableA 
where 
  field1>n and 
  field2=i;

now i want to permit user to also filter by keyword
something like

select 
  ...
from 
  tableA 
where 
  field1>n and 
  field2=i and 
  (FieldVarcharDescr like '%Keyword1%' or FieldVarcharDescr like '%Keyword2%')

How to do this ?