Hi all,

Several examples are available to do text-search on a MSSQL database field with the SQL command FREETEXT.
Works like a charm.

We recently converted to MYSQL. Works without a hitch. Speed is comparable. Cost are lower.
But there is one caveat not solved. The FREETEXT command doesn't exist and full-text search on database stored PDF and DOCX is not possible (as far as i know)

Q: Does anyone know what the equivalent commands are in MYSQL-sql and how to use them in Dataflex?

Roel