Searching BLOB fields

Hi,
I was wondering if it is possible to search blob fields in MySQL. I
have a MySQL DB and i am using PHP. I am storing Microsoft word files
in it. I am wondering if it is possible to somehow search through the
content of these words files.

Thanks

J

..oO(Jack)

>I was wondering if it is possible to search blob fields in MySQL.

Yes, if they contain plain text.

>I
>have a MySQL DB and i am using PHP. I am storing Microsoft word files
>in it.

Why in the DB and not as plain files?

>I am wondering if it is possible to somehow search through the
>content of these words files.

Not with MySQL, since a .doc is usually a binary.

Micha

On 20 Jul, 03:31, Jack <accpac...@hotmail.com> wrote:
> Hi,
> I was wondering if it is possible to search blob fields in MySQL. I
> have a MySQL DB and i am using PHP. I am storing Microsoft word files
> in it. I am wondering if it is possible to somehow search through the
> content of these words files.
>
> Thanks
>
> J


Of course its possible. You just need to read the file from the
database, open the OLE package, extract the right data stream,
linearize it, strip the formatting parse out the words, create links
in the search dictionary for words not in the exclusion list and Bob's
your uncle.

Oh....you meant is it *practical*.....no

Keep them on the filesystem and use mnogo search using wv for an input
filter.

Better yet use OpenOffice.

C.