Subject | How to do a full text search ? |
---|---|
Author | nathanelrick |
Post date | 2012-03-23T14:12:45Z |
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 ?
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 ?