BUG????select blob from tab where field like '%q%'

[eoinymc]

Hi,

I'm getting a null value from the following select statement:

select blob from table where field like '%query%';

this returns null even if the answer isn't null!!

I'm using mysql version 4.0.12.....on a few websites I've seen, it says that this bug was fixed before the version I'm using, so therefore it should work...

I don't want to update my mysql if it isn't going to make a difference..

can someone let me know if it should work in the version I have?

Thanks,

Eoin

[Xnuiem]

I would move to at least 16 if you still want to use blobs, since I still had trouble with them.

However, I suggest moving to TEXT fields if you are not storing binary, and they will work.

[eoinymc]

Cheers man....

that worked a treat!