MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 22 1999 7:21pm
Subject:Re: case sensitive and BLOBS
View as plain text  
At 12:57 PM -0600 3/22/1999, efrazier@stripped wrote:
>I wrote a while ago about how to do a case insensitive search on a text
>field and got back they way of doing it with LIKE '%searchterm%' which works
>great, but I am finding that when doing this on a LONGBLOB field it does not
>do a case IN sensitive search. Is this something weird about long blobs or
>am I just messing something up?
>select * from pinklisting WHERE _desc LIKE  '%guild%';

That's how BLOB columns work.  You might want to use ALTER TABLE
to convert your column to LONGTEXT instead.

Paul DuBois, paul@stripped
Northern League Chronicles:
case sensitive and BLOBSefrazier22 Mar
  • Re: case sensitive and BLOBStony22 Mar
  • Re: case sensitive and BLOBSPaul DuBois22 Mar
Re: case sensitive and BLOBSFred Lindberg22 Mar