🚀 go-pugleaf

Hi Giuliano

Thanks for your response,
but I have not succeeded now, I try to use "LIKE" keyword according by your
said,  but It always find the records that included the appointed content at
the front of  appointed field. If the appointed content is at the middle or
end of the field, it can not find it. Could you tell me a better way to do
it, thanks in advance.

"Giuliano" <gcardinali@remove.adhoc.net> wrote in message
news:q3jkku0edmlan5gv4rjs41ir7of9jedme0@4ax.com...
> On Fri, 2 Aug 2002 16:50:31 +0800, "HuangC" <HuangC913@Msn.com> wrote:
>
> >I want search in database that accord my request, I can do some simply
> >query, now I want search the record that include a keyword in one field,
not
> >all the content of the field
> >Can I use a SQL statement to query the accordant record.
> >
> >For example: suppose I have a Database that about pathology, I want
search
> >all the record that include 'cancer' in 'diagnose' field, It't include,
not
> >always all the content.
>
> Try something like this:
>
> SELECT * FROM PATHOLOGY
> WHERE DIAGNOSE LIKE "%CANCER%"
> OR DIAGNOSE LIKE "%ANOTHER_DISEASE%"
> OR ... and so on
>
> ... or a "case insensitive" version:
>
> SELECT * FROM PATHOLOGY
> WHERE UPPER( DIAGNOSE ) LIKE "%CANCER%"
> OR UPPER( DIAGNOSE ) LIKE "%ANOTHER_DISEASE%"
> etc etc
>
> Ciao!
>
> Giuliano