[Zope-DB] Best practice for an OracleText CONTAINS query from ZOPE
support at getcited.org
Tue Aug 24 11:34:50 EDT 2004
Lest anyone get frustrated trying to execute this statement, permit me to
note that it requires >0 at the end:
SELECT foo FROM bar WHERE CONTAINS(bar.foo,'Search String') > 0
> Thorsten Henrici wrote at 2004-8-21 22:41 +0200:
> >I would like to issue a
> >SELECT foo FROM bar WHERE CONTAINS(bar.foo,'Search String')
> >As far as I know this can't be done with a ZSQL method.
> Try it ( ;-) ), it will work...
More information about the Zope-DB