Re: Keyword Search

[Sasha Pachev]

"Naveen Yawanarajah (GTP)" wrote:
> 
> Hi All,
> 
> I'm trying to search a database using a keyword type search facility under
> the C
> API. I have a string variable containing the words to be looked for. The
> words typically on exist in one field of a table.. I know I can easily copy
> the contents
> of the field to another string variable and search it by writing C code,
> but is there any way of doing keyword searches in SQL itself?
> 
> Naveen
> 
>

Could you be more specific?

If you are talking about searching for a substring in a char or text
field, you need LIKE ( WHERE str LIKE '%stuff%').

If you are looking for something else, please explain it in more detail.

-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)