[Zope] ZCatalog to Search MySQL field?

[John P. Withers]

All,

I am just getting my feet under me with Zope and trying to figure out
how to get the following functionality.

I have a MySQL table with a notes field that stores, as you might
expect, notes about a record. I need to get a reasonably functional
search capability for this field (boolean AND and NOT at least) that
returns the serialnumber field of the record it is attached to.
Upgrading to the latest version of MySQL isn't optimal.

The Text Index capabilities of the ZCatalog object seem to be perfect
for my needs, but I can't figure out how I would implement the ZCatalog
object to search the notes field through my ZSQL object.

I could write a script to get the functionality I want, but don't want
to reinvent the wheel and would also like to grok how the ZCatalog works
anyway.

Is this doable and can someone either tell me how to do it or point me
to documentation that would be readable by a capable novice?

Thank you for your time.

John P. Withers