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

[Ismael L. Donis Garcia]

Test with

select 
...
from 
tableA  t
where 
t. || :NameFile1 || like %'' || :keyword1 || %'' or t. || :NameFile2 || like 
%'' || :keyword || %''

Best Regards
=========
|| ISMAEL ||
=========
  ----- Original Message ----- 
  From: nathanelrick 
  To: firebird-support@yahoogroups.com 
  Sent: Friday, March 23, 2012 10:12 AM
  Subject: [firebird-support] How to do a full text search ?


    
  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 ?



  

[Non-text portions of this message have been removed]