case insensitive blob

[Anon]

Is it possible to do a case insensitive search in a blob field in MySQL?

I've been told that 'like' is not case sensitive, but when i execute the query below i only get results that match the query exactly.

select * from mytable where (blobfield like 'sometext') order by ursux_id desc;

Thanks in advance,

Ben

[rdhatt]

Perhaps you should convert your BLOB to a TEXT field. According MySQL docs, TEXT is a case-insensitive BLOB.

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#BLOB

[Anon]

ah, many thanks 😉 I shall make the changes and see what happens.